dateAdd
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 | 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. |
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.