Brian Dunning's FileMaker Custom Functions

Easter_Sunday ( TheYear )

Calculate gregorian easter sunday method by Gauss

  Average rating: 4.8 (26 votes) Log in to vote

Menno van Beek   Menno van Beek
Van Beek Zakelijke Software
https://www.vbzs.nl

Share on Facebook Share on Twitter

  Sample input:
2012
  Sample output:
2012-04-08 (depending on systemformat)

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

Yet another formula to calculate easter.

The advantage of this one is that it follows the method by C.F.Gauss, published in 1800, that it's very short and does not depend on other custom functions.

It gives accurate dates from 1583 until 4000, beyond 4000 it's incorrect (filemaker doesn't calculate dates beyond 4000 anyway) and before 1583 the julian calandar was used and for that period this formula doesn't work either. For modernday use with the gregorian calander this formula suffices.

 

Comments

Vaughan   Vaughan, Sydney AUstralia
Oct 22, 2012
Great work.

I have taken the liberty of using your code in a custom function I have created to work out holidays in Australia.

I have given you credit in this new cf.

HolidaysAUS()
http://www.briandunning.com/cf/1494
 

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.