How can I calculate the due date considering non-working days?

Talles Silva

Hello, Community!

I'm working on an automation to set the due date for my issues and I'm confused about the non-working days I've set.

Example:

I created an issue today, November 27th, and put our non-working days of November 29th and December 11th to test (because if the priority was URGENT, the due date would be November 29th; if the priority was HIGH, the due date would be December 11th).

It turns out that when I set the Priority to URGENT, the due date should be changed to November 30th instead of November 29th (because November 29th is set as a non-working day) and when I set the Priority to HIGH, the date due date should be changed to December 12th instead of December 11th (because December 11th is set as a non-working day).

I'm using plusBusinessDay in my rule, but I think that is not working.

Can someone help me, please?

Thanks in advance,
Talles.

 

Bill Sheboy

Hi @Talles Silva 

Unfortunately automation rules, like many features of Jira boards, do not use the non-working days customers configure for projects.  There are lots of suggestions to improve this with Jira, including for automation rules.

The only work-arounds I know for this symptom are:

• When incrementing by business days, add a series of if / else blocks to further increment dates when non-working days are in the date range.  This solution is brittle and does not scale well for multiple rules in a Jira site.
• Create an external service which can handle date increments with non-working days, and call that service using the Send Web Request action, passing the date and increment amount.  I recall a few customer posts where they did this.

Kind regards,
Bill