dateAdd
Use the dateAdd function to add a date unit to a DateTime value.
Function format
dateAdd(Text date unit type, Integer date unit, DateTime value)
- date unit type: the type of date unit to add to the value. Specify years, months, weeks, days, hours, or seconds.
- date unit: the number date units added to the DateTime value.
- value: the value which the date units are added to.
dateAdd example
In the following example formula, the Form.EndDate DateTime variable value is 04 Oct 2018.
dateAdd("years", 2, Form.EndDate)
This formula returns the DateTime value of 04 Oct 2020.