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

Type: Function

Function: END_OF_WEEK

Syntax: END_OF_WEEK(datetime)

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

Sample usage:

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

  • END_OF_WEEK() is equal to END_OF_WEEK(NOW())

Did this answer your question?