Brian Dunning's FileMaker Custom Functions

HolidayListByYear ( yearNumber )

Creates a list of holiday names and dates for a given year.

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

Jonathan Mickelson   Jonathan Mickelson - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
HolidayListByYear ( 2004 )
  Sample output:
"New Year's Day = 1/1/2004¶
Martin Luther King Day = 1/19/2004¶
..."

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

This function returns a list of US (can be modified for other countries) Holiday Names for the supplied 4 digit Year, followwed by a "=" and its actual date that year. The list of Holidays can be found/modified/expanded in the Variable declarations within the calculation.

NOTE: This function requires the use of another custom function called: "DateByDayOccur" which performs date calculations for holidays which occur on certain occurances of a day within a month, as in the example of Thanksgiving which falls on the "Fourth Thursday of November".

Output: Text value List of Holiday Names followed by "=" and the date

HolidayListByYear ( 2004 ) = "New Year's Day = 1/1/2004¶
Martin Luther King Day = 1/19/2004¶
..."

Parameters: yearNumber - any valid 4 digit Year

Special thanks: To Dan Kaplan, of abledesign.com for distilling
many holiday/calendaring sources on the net.

 

Comments

Sterling Ledet   Sterling Ledet, Atlanta, GA
Aug 14, 2016
The Thanksgiving Day subroutine is inconsistent with the other ones and is missing a space. Should be
"Thanksgiving Day = " &
DateByDayOccur ( Y ; 11 ; 5 ; 4 ) & "¶"
 
Jonathan   Jonathan, Los Angeles
Mar 6, 2017
Thanks for the note Sterling, this has now been fixed in the source on this site.
 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: