Function: dateAdd()
Add or subtract time to or from a date.
Syntax
dateAdd(date,dateField,dateValue)
| Argument | Description | |
|---|---|---|
| date | The original date or date-time. For the current date-time use the attribute function now(). | See Date-Time Functions for details about the arguments. |
| dateField | The part of the date-time to be changed. | |
| dateValue | A whole number to add to the date-time. To subtract a number, use a negative value. Non-integer values are rounded down and any decimal places will be ignored. |
Examples
dateAdd(now(),_MONTH, -3)
Returns a date and time value three months before the current date and time.