The AddDays function is a built-in function that adds n days to dt and returns a valid date and time.

Input parameters

dt: Date Time Type

n: Integer Type

Output parameters

Date Time Type

Examples

Usage

Result

AddDays( #2015-09-14#, 15 )

#2015-09-29 00:00:00#

AddDays( #2015-12-31#, 1 )

#2016-01-01 00:00:00#

AddDays( #2015-02-28#, 1 )

#2015-03-01 00:00:00#

AddDays( #2013-02-28#, 1 )

#2013-02-29 00:00:00#

See Also

Available Data and Time Functions | Available Built-in Functions