EndOfMonth
Returns the last day of the month of a Date value.
See Sigma's Common Date Functions and Use Cases lab for more information about date functions, including use cases and exercises.
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.