EndOfMonth

Returns the last day of the month of a Date value.

Usage

EndOfMonth(date)

date (required) The date from which the end of month is to be computed.

Example

Extract the last day of the month from the [Invoice Date] column:

EndOfMonth([Invoice Date])

EndOfMonth(Date("2023-03-07"))

• Returns 2023-03-31 23:59:59.