| 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). This must be a whole number. If it is not an integer it will be 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(),_DAY, 3)
Returns a date and time value three days after the current date and time.
dateAdd(now(),_MONTH, -3)
Returns a date and time value three months before the current date and time.
See Also
...
dateAdd(now(),_YEAR, 1)
Returns a date and time value 1 year after the current date and time.
| Excerpt |
|---|
|
dateAdd(date, dateField, dateValue) Add or subtract time to/from a date. |