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.
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:
- Returns 2023-03-31 23:59:59.