Date.Year
Which year a date, datetime or datetimezone falls in, such as 2024.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.Year(dateTime as any) as nullable number| Parameter | Type | Description |
|---|---|---|
dateTime | any | A date, datetime or datetimezone value; null gives null. |
Returns
nullable number. The year, such as 2024.
Remarks
- For a datetimezone the year is read from its own clock time, not from UTC.
Examples
The year of an order
Date.Year(#date(2024, 3, 15))2024New Year's Eve in New York
Date.Year(#datetimezone(2024, 12, 31, 23, 30, 0, -5, 0))2024In UTC it is already 2025, but the value's own clock says 2024.