Brian Dunning's FileMaker Custom Functions

ITC_date__WorkingDayNext ( inputDate ; HolidaysList )

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

  Average rating: 4.2 (35 votes) Log in to vote

SL   SL
ITC

Share on Facebook Share on Twitter

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

  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.
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 preceding working day: "ITC_date__WorkingDayPrevious") 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.
The "ITC" trailer let me sort my CFs all together among 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.

 

Comments

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.