PrevWorkDay ( TheDay ; HolidayList )

returns the previous work day, excluding a list of holiday dates

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

Tim Whisenant
Whiz
none

Sample input:

PrevWorkDay ( Date(9;2;08), return separated list including 9/1/2008 )

Sample output:

8/29/2008

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

/* This function returns the previous work day, excluding a list of holiday dates passed as a parameter.
     Dependencies: requires custom funcion -  DifferenceValues ( ListA; ListB ) by Koen Van Hulle, SHpartners.
Tim Whisenant 8/25/08 */

Let ( [
yesterday = TheDay - 1;
notweekend = Case ( DayOfWeek ( yesterday )  = 1 ; yesterday - 2; DayOfWeek ( yesterday )  = 7 ; yesterday - 1; yesterday );
targetdate = DifferenceValues ( notweekend ; HolidayList )
] ;

Case ( IsEmpty ( targetdate ); PrevWorkDay( notweekend; HolidayList); targetdate ))

This function returns the previous work (week) day, excluding a list of holiday dates passed as a parameter.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

PrevWorkDay ( TheDay ; HolidayList )

Comments

Support this website.

Support this website.