%YEARS Function
%YEARS built-in function converts a number into a duration that can be added to a date or timestamp value.
%YEARS (Number)
Parameters
Number
Required. The number to be converted to duration and added to or subtracted from a date or timestamp value.
Remarks
%YEARS can only be the right-hand value in an addition or subtraction operation. The left-hand value must be a date or timestamp. The result is a date or timestamp value with the appropriate number of years added or subtracted. For a date, the resulting value is *ISO format.
In most cases, when adding or subtracting a duration in years, the general rule is that the year portion is increased or decreased by the number of years in the duration and the day portion is unchanged. There are exceptions resulting when the day portion will exceed the actual number of days in the resulting month/year. In this case, the resulting day portion is adjusted to the actual month end date. See Adding or Subtracting Dates for more information.