dateAdd

Function: dateAdd()

Add or subtract time to/from a date.

Syntax

dateAdd(date, dateField, dateValue)

ArgumentTypeDescription
dateDateThe original date/time
dateFieldDate FieldThe part of the date to be added subtracted (e.g. days or seconds)
dateValueDate ValueThe 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.

See Also