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
------------------------------
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
------------------------------