Calculates a date value by adding years to (or subtracting years from) a specified date value.





a date, or an expression that evaluates to a DATE data type


a number, or an expression that evaluates to a number

Return Value

Number, representing a DATE value.


Use $addyears to perform arithmetic with date values. The $addyears function calculates a date value by adding a number representing years to a date value. If number is negative, the effect is to subtract the years from the date.

The + (add) and - (subtract) operators can be used to achieve the same results.

If date or the result of the $addyears expression is an invalid date (e.g., 19930231), it is adjusted to produce a valid date (e.g., 19930228).


If $Date has the value 19981225, then


Evaluates to 20041225.


Evaluates to 19931225.


Evaluates to 19990228.


Related Topics