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

Talles Silva November 27, 2023

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

non-working days.png
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.

action.png

Can someone help me, please?

Thanks in advance,
Talles.

 

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 27, 2023

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events