How to calculate business days including Bank Holidays?

Question

Hello Community,

We are using Jira Cloud Premium.

I'm trying to calculate duration (working days) between 2 custom date fields (e2e tests start and e2e tests end) using automated rule that inserts this value to another numeric field.

I calculate the number with this rule:

{{issue.customfield_13297.diff(issue.customfield_13298).businessDays}}

However Jira Cloud supports advanced management of working days (adding bank holidays/non-working days) only the Board level and I need my rule to work across one Jira project for all Epics...thus I wondered is there any way to get businessDays of one Board where these days are defined?

Or maybe there is already some known app / solution that I didn't find (I searched a lot) that allows to calculate working days including public holidays between 2 custom date fields?

Thank you in advance!

Anita

Bill Sheboy · Answer

Hi @Thies Uhlenbruch

With the current capabilities/limitations of using created variables in rule functions functions...the only possible work-around I have found for this was chaining math conditions of greater than or equal to (gte) and less than or equal to (lte) on the date: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/ as I recall those accept variables.

Kind regards,
Bill

Thies Uhlenbruch · Answer

@Bill Sheboy

Next, what I meant for the date comparison was to put your bank holiday date in a created variable as a string (e.g. 2022-01-25) and than use the date compare functions to determine if the holiday is within the range of your start/end date.  If it is, decrease the working days accordingly.

It seems that this is not possible and I don't find a practible example to compare a date with a date in a date range

Anita Domańska · Answer

Hello @Bill Sheboy !

Great thanks for your hints. I will do as you suggested and will try with the hardcoded holidays values.

To answer your last questions - I use another custom field for this, not the same as KPI EAD11 - as Im aware of the conflict.

Thanks,

Anita