Function: endOfMonth()

Usage

endOfMonth(<Date>) : Date

The endOfMonth function is used to get the last day of the month of 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

endOfMonth(#26/04/2021 12:00#, 2) => #30/04/2021 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!