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