Brian Dunning's FileMaker Custom Functions

LeapYear ( y )

Returns 1 if y is a leapyear, 0 otherwise

  Average rating: 4.4 (30 votes) Log in to vote

F.M.Expert   F.M.Expert

Share on Facebook Share on Twitter

  Sample input:
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This is the fifth LeapYear custom function in this list...



Hisc   Hisc, noplace
Nov 3, 2016
I believe this is shorter Mod ( y ; 4 ) = 0
F.M.Expert   F.M.Expert, Seattle
Nov 3, 2016
If a year is divisible by 100 then it is not a leap year ...
Hisc   Hisc, noplace
Nov 3, 2016
Leap years occur every 4 years. 25 times in 100 years. 2000 was a leap year. I have reason to believe every year divisible by 4 is leap.
Hisc   Hisc, noplace
Nov 3, 2016
Oh, I was wrong. Wikipedia showed me that, although 2000 is leap, multiples of 100 are only leap at each 4 centuries. I was completely unaware.

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.