Power Query
Search…
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
Copy link
On this page
Date.Year
Description
Category
Examples