Re: Can someone help me with a Past Due formula?

OK, this should be blank if not past due yet.  Blank will be a cleaner look than a column with many zeros.

var date EndDate = If(not IsNull([End Date]), [End Date], Today());

var number Result = ToDays($EndDate - [Due Date]);

If($Result >0, $Result)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------