| Excerpt |
|---|
|
dateAdd(date, dateField, dateValue) Add or subtract time to/from a date. |
Function: dateAdd()
Add or subtract time to /or from a date.
Syntax
dateAdd(date,dateField,dateValue)
| Type | Date date/timedateField | Date Field| 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 |
added subtracted (e.g. days or seconds)Date Value | The number of (e.g.) days or seconds to be added or subtracted (negative value). This must be a whole number. If it is not an integer it will be 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.
See Also
...
| Excerpt |
|---|
|
dateAdd(date, dateField, dateValue) Add or subtract time to/from a date. |