Brian Dunning's FileMaker Custom Functions

DateDueHolidays ( StartDate ; TransitDays ; HolidayList )

Due date from Start Date plus intervening days, adding Holidays from user-entered table

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

Steve Gerow   Steve Gerow
Abrazos Data Consulting, Inc.
http://www.abrazosdata.com

Share on Facebook Share on Twitter

  Sample input:
DueDateHolidays ( 12/17/2007 ,30 , $$holidaylist )
  Sample output:
1/18/2009

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

I use $$holidaylist, set at startup to all the future holidays from a user-entered table of holidays.

 

Comments

Shan Younker   Shan Younker, Medford, OR
Mar 5, 2009
The function works if a holiday is only one day, but if you have a mutli-day holiday, for example if the holiday is Thanksgiving and the day after and you have a one day event, the function only counts one day for the holiday. If you have a two day event then the function will return an end date that is on the weekend. I'm going to try tweaking it for these instances. I'm also going to see if I can reverse the calculation to calc a start date from an end date and duration.
 
Marco Carminati   Marco Carminati, Genova (ITALY)
Jan 8, 2010
Great feature, but I have a problem if my calculated without weekend days is equal to a Friday and that week I also have a holiday, in which case the result is a Saturday, so I changed the function in this way :
replacing
/ * enddateraw + holidaycount * /
with
WeekdaysOffset (enddateraw; holidaycount)
it seems to work(but you don't put it, in your holiday list, holidays day of the week end).
 

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.