Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Public holidays as non-business days - Email Reminders

Hello I'm using automation for jira (server) plugin to send reminders as and when tickets reach 20 business days past a date field. For that I'm using following condition

{{issue.fields.customfield_1234.diff(now).businessDays}}

From the documentation I read that only weekends can be excluded from business days. But I'm looking if there is a way to exclude public holidays (selected dates 1/1/21 ; 2/15/21, etc). 

business days.PNG

1 answer

Hi @Sarath 

That feature idea appears to be in the backlog: https://codebarrel.atlassian.net/browse/AUT-1623

Until that gets implemented, you may need to compute the business days diff by hand by checking for the holidays being in the date range.  If you are using Jira Cloud, the Create Variable action could help provide some working storage.

As another alternative, you could use a scheduled rule which updates in-progress issues once per day, accumulating holidays which have passed since starting work.  Then subtract that number from your business days calculation before checking for the 20 day threshold.

Best regards,

Bill

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Automation

New to Jira Automation - goodbye Cron (sort of), hello new project created trigger, new additions to

Hey Everyone! Simeon from the Automation team here. I'm delighted to share some new features and improvements that we are shipping to Jira automation (Cloud only). Firstly, @Sam Harding&nbsp...

2,873 views 10 23
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you