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.
Date.IsLeapYear(#date(2012, 01, 01))
true
Copy link
On this page
Date.IsLeapYear
Description
Category
Examples