Forum Discussion

RezaKhosrowabad's avatar
RezaKhosrowabad
Qrew Cadet
5 years ago

Need to stop the past due date from counting once a date is entered in the Return date field.

Hello, My past due date field has the following formula. Need to stop the past due date from counting once a date is entered in the Returned date field. All fields on same table. If(Today()-[D...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
var date EndDate = Min(Today(), [Returned Date]);

If(
$EndDate-[Due Date]>Days(0),"<div style='color:red;'>" & ToDays($EndDate-[Due Date]) & "</div>",
$EndDate-[Due Date]<=Days(0), "0")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RezaKhosrowabad's avatar
RezaKhosrowabad
Qrew Cadet
5 years ago
Hello Mark,
When i enter this formula, the Returned Date turns yellow and it says that the Returned date is not identifiend.
what does that mean?
thank you,
Reza

------------------------------
Reza Khosrowabadi
------------------------------