FileMaker Pro Custom Functions

/* calculates number of days between 2 dates; parameter for counting weekends and holidays Variables -startDate, beginning date to start calculations from -endDate, ending date for function -numDays, serves as a counter for the total number of days; pass the function a 0 to start with; the function will increment this counter each time through the loop and return the final value -holidayList, global with all holidays, must be populated before calling function -countWeekends, true - weekends and holidays will be counted in numDays -returnNeg, return negative number if end date is before start date, pass empty value "" for first pass through function, the function will handle this parameter from there -these are only used within the function -tempEndDate, used only within the function -exitFunction, determines when to exit function and return result, only used within the function */ Let ( [ // increment or decrement endDate accordingly tempEndDate = Case ( endDate > startDate; endDate - 1; startDate > endDate; endDate + 1 ); //first time through function determine if negative numDays should be returned. returnNeg = Case ( IsEmpty ( returnNeg ); Case ( endDate > startDate ; False; startDate > endDate; True )); //add one day to numDays or flag to exit function numDays = Case ( startDate = endDate; 0; //no count, start and end are same countWeekends; endDate - startDate; //count all days, including weekends and holidays DayOfWeek ( tempEndDate ) = 1 or DayOfWeek ( tempEndDate ) = 7 or ValueCount ( FilterValues ( tempEndDate; HolidayList )) > 0 ; numDays; //no count, weekend or holidays numDays + 1 ) ; //calc function exit exitFunction = Case ( startDate = endDate ; True ; startDate = tempEndDate ; True ; countWeekends; True; False ) ] ; Case ( exitFunction; If ( returnNeg ; 0 - numDays ; numDays ); CalcDaysBetween ( startDate; tempEndDate; numDays; holidayList; countWeekends; returnNeg ) //call function again as necessary ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.