Power Query
Search…
Date.IsLeapYear

Date.IsLeapYear

Indicates whether this date falls in a leap year.
function (optional dateTime as nullable any) as nullable any

Description

Indicates whether the given datetime value dateTime falls in is a leap year.

Category

Date

Examples

Determine if the year 2012, as represented by #date(2012, 01, 01) is a leap year.
1
Date.IsLeapYear(#date(2012, 01, 01))
Copied!
true
Last modified 3yr ago