Blue Relay allows the use of setting up a list of public holidays that will be skipped when using “business” in expression languages.

It also allow to setup normal business hours when using “business hours” in expressions

Expression Examples

Using “business days” in an expression string (for example Task Due Date custom field, or Workflow Activation Date custom field) will only count weekdays and non holidays.

Ex. “10 business days” or “10 business days ago”

Using “business hours” in an expression string will only count the business hours (setup using time.business_start and time.business_end in the System Config page) from Monday to Friday, and exclude all holidays setup.

Ex “10 business hours” or “10 business hours ago”

Public Holidays Setup

To setup holidays a dataset with the same name as specified in the System Config setting “application.public_holidays_dataset” is needed for each company in Blue Relay. This dataset can look like whatever, but must have at least one column that has the date of the holiday in yyyy-MM-dd format that is setup as the primary key of the dataset - as this is what will get matched against the dates to skip.

An unfilled dataset will be autogenerated for each company already in Blue Relay, but when adding a new company it will have to be created. It’s name will be “System - Public Holidays”.

It’s recommended to fill the dataset out with the dates of holidays for the current and next year (to account for custom dates say 300 business days in future”.

Example dataset

Holiday

Date (Primary Key)

New Years Day

2022-01-01

Christmas

2022-12-25

New Years Day

2023-01-01

Business Hours Setup

In order for business hours to know when your business start and ends there needs to be two variables added to system config with values in 24 hour format:

  • time.business_start - 9

  • time.business_end - 17