AdjustMonth(Date date, Numeric months)

Returns the date that is a number of months after the given date, with the same day number.

Parameters

date

The starting date.

months

The numeric value specifying the month adjustment.

Returns

Date

Remarks

If the resulting date does not exist in the adjusted month, the last day of that month is returned.

Examples

• AdjustMonth(#2013-03-20#, 5) returns the date value 8/20/2013.
• AdjustMonth(#2013-03-20#, -2) returns the date value 1/20/2013.
• AdjustMonth(#2013-01-30#, 1) returns the date value 2/28/2013.