Brian Dunning's FileMaker Custom Functions

LeapYear ( Year ; Tipe )

Calculates if a certain year is a leap year.

  Average rating: 3.9 (35 votes) Log in to vote

Miguel Angel   Miguel Angel

Share on Facebook Share on Twitter

  Sample input:
LeapYear ( Year ; "T" ) or LeapYear ( Year ; "B" )
  Sample output:
"Leap Year" or 1

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

In the leap year years February is 29. This is the base to calculate if the given year is or non a leap year.
If the Year parameter is not a valid number it gives back "error". If the parameter Type is not "T"
it gives by defect that is "B".

 

Comments

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.