Brian Dunning's FileMaker Custom Functions

Name ( param ; param ) shipByDate ( startDate ; numberOfDays ; satu

Tells you the date you need to ship a package by in order to arrive at a desired date. Accounts for non-working days.

  Average rating: 4.4 (27 votes) Log in to vote

Tim Flynn   Tim Flynn
beezwax datatools
http://www.beezwax.net

Share on Facebook Share on Twitter

  Sample input:
shipByDate ( 1/20/2007 ; 10 ; "y" )
  Sample output:
1/9/2007

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

Tells you the date you need to ship something by in order for it to arrive by any date you provide while accounting for working days. Allows for designation of whether or not Saturday is a working day or not.

 

Comments

HazMatt   HazMatt, Blaine, MN
Jan 12, 2015
I tried using this CF and if I plug in the sample data:
1/20/2007; 10; "y"
I get this error message:
"Sorry, there is not enough memory to complete this operation."
 

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.