Exclude Bank Holidays from Absence Days calculation
Summary:
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):
21c
Code Snippet (add any code snippets that support your topic, if applicable):