Leap Year 06-18-2018 09:54 AM - last edited 10-30-2019 18:08 PM

[Greg_Deckler]

Simple leap year calculations for returning days in year and whether or not a year is a leap year.

DaysInYear

DaysInYear = 
VAR __Year = INT(MAX(Years[Year]))
VAR __Div4 = IF(MOD(__Year,4)=0,TRUE(),FALSE())
VAR __Div100 = IF(MOD(__Year,100)=0,TRUE(),FALSE())
VAR __Div400 = IF(MOD(__Year,400)=0,TRUE(),FALSE())
VAR __IsLeapYear = IF(__Div4 && NOT(__Div100),TRUE(),IF(__Div4 && __Div100 && __Div400,TRUE(),FALSE()))
VAR __DaysInYear = IF(__IsLeapYear,366,365) 
RETURN __DaysInYear

IsLeapYear

IsLeapYear = 
VAR __Year = INT(MAX(Years[Year]))
VAR __Div4 = IF(MOD(__Year,4)=0,TRUE(),FALSE())
VAR __Div100 = IF(MOD(__Year,100)=0,TRUE(),FALSE())
VAR __Div400 = IF(MOD(__Year,400)=0,TRUE(),FALSE())
VAR __IsLeapYear = IF(__Div4 && NOT(__Div100),TRUE(),IF(__Div4 && __Div100 && __Div400,TRUE(),FALSE()))
RETURN __IsLeapYear

eyJrIjoiNmJjYTVlY2UtZTIyZS00NWU5LThkZTAtMjg3MTUwYjlmNDdlIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9