Power Query
published
Search
⌃K

Date.Year

Date.Year

Returns the year component.
function (optional dateTime as nullable any) as nullable any

Description

Returns the year component of the provided datetime value, dateTime.

Category

Date

Examples

Find the year in #datetime(2011, 12, 31, 9, 15, 36).
Date.Year(#datetime(2011, 12, 31, 9, 15, 36))
2011