Demonstrates how to calulcate business / working days. Please check with Omfax Systems support before following this guide as this example below relies on...
The syHolidays table being populated with all public holidays
The SQL function fn_DueDate being present (possibly not the case in older Keyfax versions)
Two script steps demonstrate this; the first asks for the number of business days and stores it in a Databox named Script.Business Days:
Example script demonstrating Business Days calculation
This SQL Query Databox executes the function fn_DueDate, supplying the Databox above and a country code (ENgland). The expression PlusBusinessDays is the one of interest:
