DATEADD

The DATEADD function adds a number to an existing date, date/time, or time variable.

Syntax

DATEADD('dString', number[,DAY or MONTH or YEAR or HOUR or MINUTE])

DATEADD('time field', number[,DAY or MONTH or YEAR or HOUR or MINUTE])

DATEADD('date field', number[,DAY or MONTH or YEAR or HOUR or MINUTE])

DATEADD('time and date field', number[,DAY or MONTH or YEAR or HOUR or MINUTE])

where number represents a day, month, year, hour, or minute.

If the first argument is of type time, only hour or minute are allowed as the last argument.

Return

Date in the format defined by Date Format

Examples

DATEADD('11/24/1963', 6) = '11/30/1963 12:00 AM'
DATEADD('01/24/1964 12:12 PM', 6, 'MONTH') = '07/24/1964 12;12 PM'
DATEADD('02:12 PM', 40) = '02:52 PM'