Brian Dunning's FileMaker Custom Functions

shipArrivalDate ( startDate ; numberOfDays ; saturday )

Shows a shipping arrival date while taking into account non-ship days (sat sun).

  Average rating: 4.3 (33 votes) Log in to vote

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

Share on Facebook Share on Twitter

  Sample input:
shipArrivalDate ( 1/1/2007 ; 10 ; "y" )
  Sample output:
1/11/2007

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

Use this when trying to determin how many working days it will take for a package to arrive or a check to clear. This allows you to specify whether Saturday is a working day or not (use "y" if you wish Sat. to be a working day, leave blank otherwise).

 

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.