startofweek()
Learn how to use the startofweek() function to return the start of the week for the given date.
Returns the start of the week containing the date, shifted by an offset, if provided.
Start of the week is considered to be a Sunday.
Syntax
startofweek(date [, offset ])
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime | ✔️ | The date for which to find the start of week. |
| offset | int | The number of weeks to offset from the input date. The default is 0. |
Returns
A datetime representing the start of the week for the given date value, with the offset, if specified.
Example
range offset from -1 to 1 step 1
| project weekStart = startofweek(datetime(2017-01-01 10:10:17), offset)
Output
| weekStart |
|---|
| 2016-12-25 00:00:00.0000000 |
| 2017-01-01 00:00:00.0000000 |
| 2017-01-08 00:00:00.0000000 |
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.