getyear

Use the getyear function in APL to extract the year part from a datetime value. The function returns an integer representing the calendar year.

You can use getyear to group records by year when analyzing multi-year trends, comparing annual performance, or building year-level summaries. This is useful for dashboards, long-term reporting, and historical analysis.

Use it when you want to:

• Aggregate events by year for trend analysis.
• Compare metrics across years to detect growth or decline.
• Create year-level summaries across log, trace, or security datasets.

Usage

Syntax

getyear(datetime)

Parameters

Returns

An int representing the year.

Use case examples

['sample-http-logs']
| extend year = getyear(_time)
| summarize request_count = count() by year
| sort by year asc

['otel-demo-traces']
| extend year = getyear(_time)
| summarize trace_count = count() by year, ['service.name']
| sort by year asc

['sample-http-logs']
| where toint(status) >= 400
| extend year = getyear(_time)
| summarize error_count = count() by year
| sort by year asc

List of related functions

• getmonth: Extracts the month number from a datetime as an integer.
• dayofyear: Returns the day number within the year from a datetime.
• monthofyear: Returns the month number from a datetime. Equivalent to getmonth.
• startofyear: Returns the start of the year for a datetime, useful for year-level binning.
• endofyear: Returns the end of the year for a datetime value.

Other query languages