Power Query
published
Search
⌃K

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.
Date.IsLeapYear(#date(2012, 01, 01))
true