Business Days

How to add business days to today's date.

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:

SQL Databox

This Message references both Databoxes:

Message to display the results

For example...

The results as seen by the end-user

Last updated