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-January-2020) which results in 16-January-2020.

      ADD_DAYS Operation (1)

       

      What's Next?