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). This must be a whole number. If it is not an integer it will be rounded down and any decimal places will be ignored.

dateAdd(now(),_MONTH, -3)

Returns a date and time value three months before the current date and time.