dateAdd

Function: dateAdd()

Add or subtract time to or from a date.

Syntax

dateAdd(date,dateField,dateValue)

ArgumentParameter TypesDescription
dateDateThe original date or date-time. For the current date-time use the attribute function now().
dateFieldSee Date-Time FunctionsThe element of the date-time to be changed, for example the month or seconds.
dateValueA whole number to add to the date-time element. To subtract a number, use a negative value.
Non-integer values are rounded down and any decimal places will be ignored.

Examples

dateAdd(now(),_DAY, 3)

Returns a date and time value three days after the current date and time.


dateAdd(now(),_MONTH, -3)

Returns a date and time value three months before the current date and time.


dateAdd(now(),_YEAR, 1)

Returns a date and time value 1 year after the current date and time.