Public holidays as non-business days - Email Reminders

Sarath_j934gs

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). 

Bill Sheboy

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