Determining if a year is a leap year

[j1fergu]

I used the following formula today to determine if a year was a leap year.  Thought I would share in case others needed this as well.  

IF IsInteger([YEAR]/400) THEN "YES" ELSEIF IsInteger([YEAR]/4) AND !IsInteger([YEAR]/100) THEN "YES" ELSE "NO" ENDIF

[Maskell_Rascal]

Hey @j1fergu 

Thanks for sharing! Here is the formula I use for finding a Leap Year. 

DateTimeFormat(DateTimeTrim(ToString([Year])+'-02-01','lastofmonth'),'%d')='29'

Since we know that every leap year will have 29 days in February, I use the datetime functions to find the last day Feb for each year. 

Cheers!

Phil