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,
No end date. i review a file. about 30 days to respond which is the due date. anytime after the due date is past due and no end date. just counting the days after the due date.
thanks.
------------------------------
Reza Khosrowabadi
------------------------------
No end date. i review a file. about 30 days to respond which is the due date. anytime after the due date is past due and no end date. just counting the days after the due date.
thanks.
------------------------------
Reza Khosrowabadi
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHow does the record know when you have reviewed the file? Otherwise the past due counter will just count up forever.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I have a review date and a due date and i need a past due date which is any number of days after the due date.
thanks.
------------------------------
Reza Khosrowabadi
------------------------------- I review a file today which is my review date. i give the department about 30 days to respond. this is my due date.
now i need a formula for Past Due date which is any number of days passed the due date with no end date.
i hope this helps.
thank you.
------------------------------
Reza Khosrowabadi
------------------------------ - MarkShnier__YouOK, so you do hav an additional field which is part of this formula. :) The review date is the date that you completed the review.
try this
var date EndDate = If(not IsNull([Review Date]), [Review Date], Today());
ToDays($EndDate - [Due Date])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- MarkShnier__YouI did not see you most recent post
use this
var date EndDate = If(not IsNull([End Date]), [End Date], Today());
ToDays($EndDate - [Due Date])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------