endofweek()
Learn how to use the endofweek() function to return a datetime representing the end of the week for the given date value.
Returns the end of the week containing the date, shifted by an offset, if provided.
Last day of the week is considered to be a Saturday.
Syntax
endofweek(date [, offset])
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime | ✔️ | The date used to find the end of the week. |
| offset | int | The number of offset weeks from date. Default is 0. |
Returns
A datetime representing the end of the week for the given date value, with the offset, if specified.
Example
range offset from -1 to 1 step 1
| project weekEnd = endofweek(datetime(2017-01-01 10:10:17), offset)
Output
| weekEnd |
|---|
| 2016-12-31 23:59:59.9999999 |
| 2017-01-07 23:59:59.9999999 |
| 2017-01-14 23:59:59.9999999 |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.