Date.Year

Date

Returns the year from a date value.

Syntax

Date.Year(dateTime as any) as nullable number

Parameters

Name	Type	Required	Description
`dateTime`	`any`	Yes	The date value to extract the year from.

Return Value

number — The year component of the date.

Remarks

Date.Year returns the year component as a whole number from a date, datetime, or datetimezone value. If the input is null, the function returns null.

Examples

Example 1: Extract the year from OrderDate

Table.AddColumn(
    Table.SelectColumns(
        Table.FirstN(Sales, 5),
        {"OrderID", "OrderDate"}
    ),
    "Year", each Date.Year([OrderDate]), Int64.Type
)

Result

	OrderID	OrderDate	Year
1	1	1/15/2024	2,024
2	2	1/18/2024	2,024
3	3	2/1/2024	2,024
4	4	2/10/2024	2,024
5	5	3/5/2024	2,024

Example 2: Extract the year from a scalar value

#table(
    type table [Date = date, Year = number],
    {{#date(2024, 3, 5), Date.Year(#date(2024, 3, 5))}}
)