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

      ADD_MONTHS Operation

      How to use the ADD_MONTHS operation in formulas

      Definition

      Example

      Syntax Guide

      Compatible Attributes

      Formula In Use 

       

      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)

      ADD_MONTHS Operation

      What's Next?