Calculation: Is Leap Year

Posted in Calculations by Dempsey
.

This simple calculation returns a boolean of wether the current year is a leap year or not.

Case(
IsEmpty(Current Date), TextToNum(""),
Mod(Year(Current Date),4) = 0
and
Mod(Year(Current Date),100) <> 0
or
Mod(Year(Current Date),400) =0 , 1, 0
)

Leave a Reply