DATEADD

Returns a new datetime value based on adding an interval to the specified date.

NOTE: This function is equivalent to DATEADD in T-SQL.

Return Value

Date/Time

Syntax

DATEADD( datePart, number, date )

where:

To decrement (that is, return an earlier date or time), use a negative number.

If you specify a value that is not an integer, the fractional part of the value is discarded. For example, if you specify day for datePart and 1.75 for number, the date is incremented by 1.