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 have a Review Date field(11/20/2020), and a Due Date Filed(12/20/2020.
Now, i need a formula for my Past Due date Field to show the number of days passed the due date. No end date. No completion date. Just to show the number of days passed the due Date without showing negative days before the due date.
The days before the due date should be 0 since not yet past due and to show the Past Due day number/s in red please.
i hope this helps.
thanks for all your help.
------------------------------
Reza Khosrowabadi
------------------------------
i have a Review Date field(11/20/2020), and a Due Date Filed(12/20/2020.
Now, i need a formula for my Past Due date Field to show the number of days passed the due date. No end date. No completion date. Just to show the number of days passed the due Date without showing negative days before the due date.
The days before the due date should be 0 since not yet past due and to show the Past Due day number/s in red please.
i hope this helps.
thanks for all your help.
------------------------------
Reza Khosrowabadi
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendA numeric formula field will be
var number Result = ToDays(Today() - [Due Date]);
If($Result >0, $Result)
If you wanted it to be a text field type in red that would not work in any numeric formulas, then use a formula text field type with this formula
var number Result = ToDays(Today() - [Due Date]);
If($Result >0, "<font color=red>" & ToText($Result))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var number Result = ToDays(Today() - [Due Date]);
If($Result >0, $Result)
If you wanted it to be a text field type in red that would not work in any numeric formulas, then use a formula text field type with this formula
var number Result = ToDays(Today() - [Due Date]);
If($Result >0, "<font color=red>" & ToText($Result))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks so much Mark.
------------------------------
Reza Khosrowabadi
------------------------------