END_OF_QUARTER
Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

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 the created_at field value set at 23h59m59s on the last day of the quarter. If created_at is equal to 2023-02-23T15:39:21Z then END_OF_QUARTER(created_at) returns 2023-03-31T23:59:59Z.

  • END_OF_QUARTER() is equal to END_OF_QUARTER(NOW())

Did this answer your question?