ADDDAYS ER function
The ADDDAYS function calculates a DateTime value that is the specified number of days before or after a specified start date.
Syntax
ADDDAYS (datetime, days)
Arguments
datetime: DateTime
A date/time value that represents the start date.
days: Integer
The number of days before or after datetime.
Return values
DateTime
The resulting date/time value.
Usage notes
A positive value for days yields a future date. A negative value yields a past date.
Example 1
ADDDAYS (NOW(), 7) returns the date and time seven days in the future.
Example 2
ADDDAYS (NOW(), -3) returns the date and time three days in the past.