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.

Additional resources

Date and time functions