Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

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 - Show more from this author Abrazos Data Consulting http://www.abrazosdata.com

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

/* DateDueHolidays [ StartDate ; TransitDays ; HolidayList ] = July 8, 2008--changed to incorporate Saturday/Sunday as well as holidays. For creating a due date from a start date plus lead days, incorporating intervening weekends and holidays. Holidays from user-entered table are set into $$holidaylist at startup by a scrpt. Requires Custom Function: "DateRange" by Andrew Persons and "WeekDaysOffset" by Nick Chapin--thanks to them. */ Let ( enddateraw = WeekDaysOffset ( StartDate ; TransitDays ) ; Let ( datelistraw = DateRange ( StartDate ; enddateraw ; 10 ) ; Let ( holidaycount = ValueCount ( FilterValues ( datelistraw ; HolidayList )) ; enddateraw + holidaycount ))) Click to copy

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

 

Comments

		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, 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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 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: