CF_IsLeapYear ( SetDate )
Calculates if the current year is a leap-year
Average rating: 4.3 (25 votes) Log in to vote
I have no website, sorry
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Just calculates if the selected date is a leap-year.
Please be sure to set the date with 4-digits year.
Dec 11, 2015
Any year which is divisible by 100 is not a leap year!
Ron Greene, Phoenix, AZ
Dec 27, 2015
IsEmpty ( SetDate ) ; "Please, set a date." ;
Mod ( Year ( SetDate ) ; 400 ) = 0 ; "The chosen date is a leap-year";
Mod ( Year ( SetDate ) ; 100 ) = 0 ; "The chosen date is NOT a leap-year" ;
Mod ( Year ( SetDate ) ; 4 ) = 0 ; "The chosen date is a leap-year" ;
"The chosen date is NOT a leap-year"
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.