DATE + NUMBER (of) YEARS ( + Operator)
The DATE + YEARS operator calculates a new date value by adding the number of years to a DATE you specify.
The DATE + YEARS operator works with a date value, which can be a date expression, a Date variable, or the result of a function that returns a date. The number of years to be added can be a number value, which can be a number expression, a Number variable, or the result of a function that returns a number.
Operator | Description | After you drag and drop the operator into the script tab: | Expression returns: |
DATE + NUMBER (of) YEARS | DATE + NUM YEARS | Replace the DATE placeholder with the date value you want to add to. Replace the NUM placeholder with the number value you want to add. | A date value. |
Example
DATE OF(31, 12, 2020) + 3 YEARS // Results in the date value 12/31/2023