You will want to use a dateadd() function to add units of time to a date field. You'll need to use this in a calculated date or date/time field since the output will also be a date.
The syntax is: dateadd({Date}, n, "unit") where:
- {Date} is a Date or Date and Time field - n is the number of units to add or subtract - unit is one of the following (include the quotation marks in your formula)
Comments
1 comment
Hi Kristy,
You will want to use a dateadd() function to add units of time to a date field. You'll need to use this in a calculated date or date/time field since the output will also be a date.
The syntax is: dateadd({Date}, n, "unit") where:
- {Date} is a Date or Date and Time field
- n is the number of units to add or subtract
- unit is one of the following (include the quotation marks in your formula)
Regards,
Alex
Please sign in to leave a comment.