ADD_DAYS Operation

How to use the ADD_DAYS operation for Computed Attributes

Definition

Example

Syntax Guide

Compatible Attributes

Formula In Use


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.

ADD_DAYS operation

 


What's Next?


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 👇