Function: dateAdd()
Add or subtract time to or from a date.
Syntax
dateAdd(date,dateField,dateValue)
| Argument | Type | Description |
|---|---|---|
| date | See Parameter Types: 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(),_MONTH, -3)
Returns a date and time value three months before the current date and time.