Forum Discussion
MarkShnier__You
Qrew Legend
5 years agovar 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
------------------------------
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
5 years agoQrew Cadet
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
------------------------------
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
------------------------------
- AdamKeever15 years agoQrew CommanderTry using [Returned] instead of [Returned Date]. In initial remarks you stated the field was "Returned".
------------------------------
Adam Keever
------------------------------ - MarkShnier__You5 years ago
Qrew Legend
you post said this
"Need to stop the past due date from counting once a date is entered in the Returned date field."
So I made the assumption that you have a field called [Returned date].
The error message says that field does not exist.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- RezaKhosrowabad5 years agoQrew CadetGreat job Mark.
Your formula worked.
thanks a lot.
Reza
------------------------------
Reza Khosrowabadi
------------------------------