AddDays

Returns a date or timestamp plus an offset (+ or -) number of days.

Syntax

AddDays(Date/Time,Offset)

Where

Date/Time is the input date or timestamp and Offset is an integer number of days to add.

For information on the syntax used in your specific database, refer to the Functions Reference.

Example

AddDays('2024-07-29', 4) = 2024-08-02

AddDays('2024-07-29 02:00:00', 4) = 2024-08-02 02:00:00

AddDays('2024-03-01', -4) = 2024-02-26