Function: addMonths()

Usage

addMonths(<Date>, <Number of Months>) : Date

The addMonths function is used to add the specified number of months to the specified date parameter.

When you use static dates, you need to enclose the value with the # symbol. The date should be in the following format - dd/mm/yyyy hh:mm

addMonths(#01/02/2017 12:00#, 2) => #01/04/2017 12:00#

Learn more about how you can get started using the Formula Field.

diffMonths()

diffDays()

diffHours()

diffMinutes()

year()

month()

monthName()

startOfMonth()

endOfYear()

dayName()

dayOfYear()

dayOfMonth()

dayOfWeek()

hour()

minute()

addYears()

endOfMonth()

addMonths()

addDays()

addHours()

addMinutes()

format()

timezone()

date()

startOfYear()

Was this article helpful?

Yes 😃 No 😞

Thanks for your feedback!