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

      ADD_MONTHS Operation

      How to use the ADD_MONTHS operation for Computed Attributes

      Definition

      The ADD_MONTHS operation adds days 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

      add-months

      Compatible Attribute Types

      • Date attributes