Function: dateAdd()

Add or subtract time to or from a date.

Syntax

dateAdd(date,dateField,dateValue)

Argument	Parameter Types	Description
date	Date	The original date or date-time. For the current date-time use the attribute function now().
dateField	See Date-Time Functions	The element of the date-time to be changed, for example the month or seconds.
dateValue	See Date-Time Functions	A 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.

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.