Brian Dunning's FileMaker Custom Functions

Easterday ( Date )

Calculates the date for any easterday according to Gauss formula.

  Average rating: 4.5 (29 votes) Log in to vote

Johan Söderberg   Johan Söderberg
Distingo Scenproduktion
http://www.distingo.nu

Share on Facebook Share on Twitter

  Sample input:
four_digit_yearfield ( 1963 )
  Sample output:
1963-04-14

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

This is a solution to calculate when Easterday will show up in the calendar year.

I made this many years ago when I was trying to develop Matt Petrovskys brilliant little calendar into something more useful. I wanted the calendar to mark all Swedish holidays and found that easterday was the only one difficult to calculate and that another three holidays were dependendant on this highly variable and seemingly unpredictable date.

With this formula all you need is a numeric field with a year in it. In the function that field is refered to as "four_digit_yearfield"

More info on Gauss formula:
http://mathforum.org/library/drmath/view/52575.html

 

Comments

comment   comment, VR
Aug 7, 2011
http://www.wheniseastersunday.com/year/1981/

Also 1954, 2049, 2076 and almost all years after 2099 and before 1900.
 

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.