How to create a field for Next Date Due
How do I create a field that calculates a "next due date" based off an initial start date and todays date (in 3 months after start date, in 6 months after start date, in 12 months after start date). ...
Forum Discussion
Try this
LastDayOfPeriod(Today(), Days(365/12*3), [Reference date]) + Days(1)
The function LastDayOfPeriod is described here
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=bn&rl=dvd
LastDayOfPeriod(Today(), Days(365/12*3), [Reference date]) + Days(1)
The function LastDayOfPeriod is described here
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=bn&rl=dvd
- I know this is an old thread, but if I can revive it...I need a similar thing but am not sure I understand date d or the +days(1)? In my case I have a set initial start date, and need a due date every quarter. So I think I can do LastDayOfPeriod(Date d, Days(365/12*3), [Initial Start Date]) + Days(1)
What is the date d, and why add the 1 day?
*Edit: Understand the date d (made it today() per this thread. Not sure of the +1 day but working for me.
------------------------------
Mike Tamoush
------------------------------- Mike,
What is the business case? Are you searching for the end of the current quarter or of a different quarter based upon a date in the record?
If you truly just need four dates for the end of each quarter
- Mar 31
- June 30
- Sep 30
- Dec 31
then a formula which returns the closest future date will suffice.
If your dates are more fluid, excluding weekends, holidays.... then you need a more complicated solution.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
