Function: dateAdd()
Add or subtract time to/from a date.
Syntax
dateAdd(date, dateField, dateValue)
| Argument | Type | Description |
|---|---|---|
| date | Date | The original date/time |
| dateField | Date Field | The part of the date to be added subtracted (e.g. days or seconds) |
| dateValue | Date Value | The number of (e.g.) days or seconds to be added or subtracted (negative value) |
Examples
dateAdd(now(),_MONTH, -3)
Returns a date and time value three months before the current date and time.