A READER ASKS: I am trying to get a date calculation and I am drawing a blank. Can you please help – see my example below.
(Field) Pick Up Date = 12/30/08
Need to add 14 business days (no weekends) to get the return date
(Return Date) = 1/19/2009
Thank you in advance for your time.
DWAYNE RESPONDS: This reminds me of AA batteries, they always seem to be in my way when I don’t want them and cannot find them when I needed them. I had done a google search, much like you probably did ... and didn’t yield very good results. I looked for a custom function at both of the most popular custom function sites and still couldn’t find anything by performing a simple search for work days.
Then, I thought about one of the biggest and longest standing collections of FileMaker resources out there ... databasepros.com. Going to the site I did a search for work days and immediately was directed to the perfect example file to meet your needs. It looks like it was written by John back in 2005 and is titled Work and Holidays .... Formulate Dates Excluding Weekends and Holidays. Here is the link and you might want to check out some of the other great example file on the site ...
If you have any resources that I missed in answering this question, please feel free to add them in the comments below and I’ll be sure to pass them along!
More info about the author and FileMaker in general, contact me at firstname.lastname@example.org.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.