AdjustYear(Date date, Numeric years)

Returns the date that is a number of years after the given date, with the same month and day.

Parameters

date

The starting date.

years

The numeric value specifying the year adjustment.

Returns

Date

Remarks

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

Examples

• AdjustYear(#2012-01-30#, 2) returns the date value 1/30/2014.
• AdjustYear(#2012-01-30#, -1) returns the date value 1/30/2011.
• AdjustYear(#2012-02-29#, 2) returns the date value 1/28/2014.