Can someone help me with a Past Due formula?
I have a start date and a due date and i want the past due date to start with 1 counting the number of days past due. thank you, Reza ------------------------------ Reza Khosrowabadi ----------...
Forum Discussion
Hello Mark,
i tried the formula and it shows negative days for the days before it reaches the due dates.
is there a way for it to start counting from the day it is passed due which is the day after the due date?
thanks.
------------------------------
Reza Khosrowabadi
------------------------------
i tried the formula and it shows negative days for the days before it reaches the due dates.
is there a way for it to start counting from the day it is passed due which is the day after the due date?
thanks.
------------------------------
Reza Khosrowabadi
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOK, 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
------------------------------
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
------------------------------
