| 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/time| date or date-time. For the current date-time use the attribute function now(). |
| dateField | See Date |
Field part | element of the date-time to be |
added subtracted (e.g. days | changed, for example the month or seconds |
)Date Value | The number of (e.g.) days or seconds to be added or subtracted (negative value)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.
See Also
...
| Excerpt |
|---|
|
dateAdd(date, dateField, dateValue) Add or subtract time to/from a date. |