Brian Dunning's FileMaker Custom Functions

DateRangewoWe ( ID ; StartDate ; EndDate )

Creates date ranges without weekend days

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

Holger Bolecke   Holger Bolecke
fmworks.de
http://www.fmworks.de

Share on Facebook Share on Twitter

  Sample input:
DateRangewoWe ( "Anytextorfields" ; 8/1/2005 ; 8/18/2005 )
  Sample output:
Anytextorfields8/1/2005
Anytextorfields8/2/2005
Anytextorfields8/3/2005
Anytextorfields8/4/2005
Anytextorfields8/5/2005
Anytextorfields8/8/2005
Anytextorfields8/9/2005
Anytextorfields8/10/2005
Anytextorfields8/11/2005
Anytextorfields8/12/2005
Anytextorfields8/15/2005
Anytextorfields8/16/2005
Anytextorfields8/17/2005
Anytextorfields8/18/2005

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

Creates date ranges without weekend days in conjunction with the "OmitWeStart" and "OmitWeEnd" functions.

 

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.