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

http://www.filemaker-magazin.de

Share on Facebook Share on Twitter

  Sample input:
LeapYear(2000)
  Sample output:
1

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

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

 

Comments

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 ...
Regards
F.M.
 
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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.