You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Exclude Bank Holidays from Absence Days calculation

Received Response
edited Oct 14, 2021 9:38AM in Workforce Management 20 comments


Bank holidays are counted in the absence days calculation for a sickness absence but should be excluded

Content (required):

We have a number of sickness absence reports built within OTBI however we have been unable to exclude the bank holidays from the absence days field i.e. 23/08/2021 - 31/08/2021 should show as 6 days for a full time employee but currently shows 7 as it includes 30/08/2021 which was a bank holiday. How do we exclude this day?

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!