Date
      Back to home
      1. Help Center
      2. Operations
      3. Date

      ADD_DAYS Operation

      How to use the ADD_DAYS operation in formulas

      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 (01-September-2025) which results in 16-September-2025.

      ADD_DAYS Operation

       

      What's Next?