Date calculations


Has anyone been able to enter a date and then have the system calculate a date 7 days out, 14 days out and 28 days out automatically in separate fields. system

1 Like


Hey Nelson,
welcome to the community :smiley:

I could not find exactly what you were looking for, but something similar. Use workday:
Replace DATEFIELD with your date attribute you want to use.
This will calculate a date after usually 14 days (which are usually 10 workdays)

Syntax: WORKDAY(start_date, num_days, [holidays])
Explanation: Calculates the end date after a specified number of working days.

Maybe you can also build something complex using DATE:
Syntax: DATE(year, month, day)
Explanation: Converts a year, month, and day into a date.

1 Like


Thank you Micck.

That worked to perfection!

Too bad we can’t take it a step further at this point and conditionally format when the date exceeds the set parameters … I’m sure it’s coming soon.


1 Like