The AddMonths function is a built-in function that adds n months 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

AddMonths( #2001-09-14#, 2 )

#2001-11-14 00:00:00#

AddMonths( #2001-12-14#, 2 ) #2002-02-14 00:00:00#

AddMonths( #2003-01-31#, 1 )

#2003-02-28 00:00:00#

AddMonths( #2004-01-31#, 1 )

#2004-02-29 00:00:00#

See Also

Available Data and Time Functions | Available Built-in Functions