Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Provides 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.
endofweek(date [, offset])
Learn more about syntax conventions.
| 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 datetime representing the end of the week for the given date value, with the offset, if specified.
The following example returns the end of the week for the specified date.
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 |