Last updated 25 days ago
Was this helpful?
Returns the last day of the month of a Date value.
EndOfMonth(date)
date (required) The date from which the end of month is to be computed.
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.
