Type: Function
Function: END_OF_MONTH
Syntax: END_OF_MONTH(datetime)
Description: Returns a datetime corresponding to the end of month for the provided datetime or NOW if no value is provided.
Sample usage:
END_OF_MONTH(created_at)returns thecreated_atfield value set at 23h59m59s on the last day of the month. Ifcreated_atis equal to2023-02-23T15:39:21ZthenEND_OF_MONTH(created_at)returns2023-02-28T23:59:59Z.END_OF_MONTH()is equal toEND_OF_MONTH(NOW())