How to use the ADD_DAYS operation for Computed Attributes
Definition
The ADD_DAYS operation adds days to a date.
Example
ADD_DAYS(‘2020-03-30’, 2)
Result:
“2020-04-01”
Syntax Guide
ADD_DAYS(date, days)
date - The date to add days to
days - The number of days you want to add to the date
Compatible Attribute Types
- Date attributes
Formula In Use
ADD_DAYS($ATT.SALE_EXPIRY_DATE,15)
In this example, the formula tells the system to add 15 days to the date in question (30-June-2020) which results in 15-July-2020.
What's Next?
- Learn more about how to write formulas
- Check out the ADD_MONTHS operation
- Check out the ADD_YEARS operation
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇