ADD_YEARS Operation
How to use the ADD_YEARS operation in formulas
Definition
The ADD_YEARS operation adds years to a date.
Example
ADD_YEARS(‘2020-03-30’, 5)
Result:
“2025-03-30”
Syntax Guide
ADD_YEARS(date, years)
date - The date to add years to
years - The number of years you want to add to the date
Compatible Attribute Types
- Date attributes
Formula In Use
ADD_YEARS($ATT.SALE_EXPIRY_DATE,1)
What's Next?
- Learn more about how to write formulas
- Check out the ADD_DAYS operation
- Check out the ADD_MONTHS operation