endofmonth()
Learn how to use the endofmonth() function to return a datetime representing the end of the month for the given date value.
Provides the end of the month containing the date, shifted by an offset, if provided.
Syntax
endofmonth(date [, offset])
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime | ✔️ | The date used to find the end of the month. |
| offset | int | The number of offset months from date. Default is 0. |
Returns
Returns a datetime representing the end of the month for the given date value, with the offset, if specified.
Examples
The following example returns the end of the month for the specified date.
range offset from -1 to 1 step 1
| project monthEnd = endofmonth(datetime(2017-01-01 10:10:17), offset)
Output
| monthEnd |
|---|
| 2016-12-31 23:59:59.9999999 |
| 2017-01-31 23:59:59.9999999 |
| 2017-02-28 23:59:59.9999999 |
Related content
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.