← Back to Date functions

Date.IsLeapYear

This function determines if a specified datetime value, dateTime, corresponds to a leap year. The input should be a date, datetime, or datetimezone value for evaluation.

Syntax

Date.IsLeapYear(dateTime as any) as nullable logical

About

This function determines if a specified datetime value, dateTime, corresponds to a leap year. The input should be a date, datetime, or datetimezone value for evaluation.

Explanation

To ascertain whether the year 2012, indicated by #date(2012, 01, 01), is a leap year, use the Power Query MDate.IsLeapYear(#date(2012, 01, 01)) function. The output will be true.