Type: Function
Function: END_OF_QUARTER
Syntax: END_OF_QUARTER(datetime)
Description: Return a datetime corresponding to the end of quarter for the provided datetime or NOW
if no value is provided.
Sample usage:
END_OF_QUARTER(created_at)
returns thecreated_at
field value set at 23h59m59s on the last day of the quarter. Ifcreated_at
is equal to2023-02-23T15:39:21Z
thenEND_OF_QUARTER(created_at)
returns2023-03-31T23:59:59Z
.END_OF_QUARTER()
is equal toEND_OF_QUARTER(NOW())