Date calculations

#1

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

#2

Hey Nelson,
welcome to the community :smiley:

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

WORKDAY
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:
DATE
Syntax: DATE(year, month, day)
Explanation: Converts a year, month, and day into a date.

1 Like

#3

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.

Cheers

1 Like