The DATE + NUMBER (of) YEARS operator calculates a new date value by adding the number of years to a DATE you specify.
The + 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. |
The expression 'DATEOF ( 11, 20, 2020 ) + 3 YEARS' results in the date value 11/20/2023.
After you download the example template, you can import the template to any workspace to see this example code in action.