how to exclude holidays from BusinessDays

Question

i have created an automation for updating a field with a specific date when creating a ticket. Adding two days from today.

I have used the below expression

it is very good for saturday and sunday but it counts public holidays

do you know who to exclude also public holidays

Vikrant Yadav · Answer

Hi @Giannis Michailidis  As @Jeroen Poismans  said, it's not feasible to exclude public holidays in A4J because Jira won't store Holidays as different region or org have different holidays.  Here is the workaround, you can try to exclude holidays :

Create an issue in Jira and create a table in Issue Description to store the Holiday for the complete year.

Using Regex compare the {{now.plusBusinessDays(2)}} result with table in Description field, if it won't match then put {{now.plusBusinessDays(2)}} in the field else if date matched then add +1 day in Result.

Similar post : https://community.atlassian.com/t5/Jira-questions/How-to-change-working-days-in-jira-automation/qaq-p/2233093

Give it a try, let me know, if you face any issue.

Thanks

V.Y

Jeroen Poismans · Answer

Hi Giannis!

Out of the box I don't know how to approach this. With Scriptrunner you will probably be able to get this done but still you would need some "place" to store your holidays.

Do you have Assets? If so you might put your holidays in an ObjectType with of course a date as an attribute. From your automation you might the lookup the assets with a date in your range (today+2).

If those assets (holidays) are found (eg 2) you can then add that extra amount of days. Do you get the idea?

Jeroen