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.