Function: diffMonths()

Usage

diffMonths(<Date>, <Date>) : Number

The diffMonths function is used to return the difference, in months, between the two specified date parameters.

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

diffMonths(#01/02/2021 12:00#, #01/05/2021 12:00#) => 3

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!