startofyear()

Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Returns the start of the year containing the date, shifted by an offset, if provided.

Syntax

startofyear(date [, offset ])

Learn more about syntax conventions.

Parameters

Returns

A datetime representing the start of the year for the given date value, with the offset, if specified.

Example

range offset from -1 to 1 step 1
| project yearStart = startofyear(datetime(2017-01-01 10:10:17), offset) 

Output

Related content

• startofday function
• startofweek function
• startofmonth function
• endofday function
• endofweek function
• endofmonth function
• endofyear function