Brian Dunning's FileMaker Custom Functions

ITC_date__WorkingDayPrevious ( inputDate ; HolidaysList )

The preceding weekday of a given date (giving a list of all your closed days!)

  Average rating: 4.6 (28 votes) Log in to vote


Share on Facebook Share on Twitter

  Sample input:
ITC_date__WorkingDayNext ( date ( 12 ; 27 ; 2007 ) ; "12/25/2007¶12/26/2007¶12/29/2007¶12/30/2007" )
  Sample output:

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

I work a lot with manufacturing worldwide companies so for me, while creating to-do and BOM list, it's very important to know exactly if a process, which need several hours or days, takes place into ferial days or not. For example: B needs three days to be assembled, so If I want to deliver it on Monday I need to start and build it on Tuesday, because Fridays is the Patron Saint of my town!
I have to avoid these kind of situations and, because every nation/county has its own working calendar, the usual weekdays Monday2Friday methods were not fitting my need!
So I wrote these CFs (oh, yes, there is another CF that calculates the next working day: "ITC_date__WorkingDayNext"), that are very fast.
I hope they could be useful to you as they were to me.

Somebody has asked me why the name of my CFs is so long.
This is my notation way for CFs. Period!
The "ITC" trailer let me sort my CFs all together when listing them among others. The second part refers to the type of data is being manipulated: string, date, number... and, finally, the last is the CF's name.



Log in to post comments.


Note: these functions are not guaranteed or supported by 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:

Under construction. Email me your wish list for improvements.