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
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
------------------------------
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
------------------------------- it is not taking the end date.
what is the end date? did you mean the review date?
------------------------------
Reza Khosrowabadi
------------------------------
- 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
------------------------------- MarkShnier__YouOK, 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
------------------------------