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

Type: Function

Function: END_OF_YEAR

Syntax: END_OF_YEAR(datetime)

Description: Return a datetime corresponding to the end of year for the provided datetime or NOW if no value is provided.

Sample usage:

  • END_OF_YEAR(created_at) returns the created_at field value set at 23h59m59s on the last day of the year. If created_at is equal to 2023-02-23T15:39:21Z then END_OF_YEAR(created_at) returns 2023-12-31T23:59:59Z.

  • END_OF_YEAR() is equal to END_OF_YEAR(NOW()) => 2021-12-31 or 2022-12-31 or 2023-12-31

Did this answer your question?