week_of_year()

Applies to: ✅ Azure Data ExplorerAzure MonitorMicrosoft Sentinel

Returns an integer that represents the week number. The week number is calculated from the first week of a year, which is the one that includes the first Thursday, according to ISO 8601.

Deprecated aliases: weekofyear()

Note

weekofyear() wasn't ISO 8601 compliant; the first week of a year was defined as the week with the year's first Wednesday in it.

Syntax

week_of_year(date)

Learn more about syntax conventions.

Parameters

Name Type Required Description
date datetime ✔️ The date for which to return the week of the year.

Returns

week number - The week number that contains the given date.

Examples

Input Output
week_of_year(datetime(2020-12-31)) 53
week_of_year(datetime(2020-06-15)) 25
week_of_year(datetime(1970-01-01)) 1
week_of_year(datetime(2000-01-01)) 52

Note

weekofyear() is an obsolete variant of this function. weekofyear() was not ISO 8601 compliant; the first week of a year was defined as the week with the year's first Wednesday in it. The current version of this function, week_of_year(), is ISO 8601 compliant; the first week of a year is defined as the week with the year's first Thursday in it.