LeapYear ( y )

Returns 1 if y is a leapyear, 0 otherwise

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

F.M.Expert - Show more from this author

http://www.filemaker-magazin.de

Sample input:

LeapYear(2000)

Sample output:

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

/* 
The shortest leap year function of all times
Version 1.1
Evaluate(Day(Date(2;29;y))=29)

Version 1.2
Now: significantly shorter :-))
*/
Day(Date(2;29;y))>1

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

Comments

		Hisc, noplace Nov 3, 2016
I believe this is shorter Mod ( y ; 4 ) = 0

		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, 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, 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.

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

LeapYear ( y )

Comments

Support this website.

Support this website.