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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,406
Community Members
 
Community Events
176
Community Groups

Calculate Due Time based upon Client's Holidays

Greetings,

Currently, we have an automation rule set up for all projects, which sets automatically a due date for all estimations we need to provide.

In this case, for example, an estimation needs to be provided within 5 working days. However, the due date needs to be calculated based on the client’s calendar. Their holidays are different to ours so if e.g an estimation is requested on 22/12, the rule will set the due date to 29/12. This is incorrect, though, because during 23/12-2/1 the client will be on holidays. Therefore, the correct due date would be 7/1.

What we currently do is check if there is a holiday and manually adjust the due date if needed, but we would like to have a way to do this without going through the manual calculation.

Is there a way to do it? Maybe a calendar add-on which we can populate with client's holiday dates. Then use that calendar to the automation mentioned above? Any other suggestions?

Thanks in advance!

automation.jpg

1 answer

Hi @ED _ DevOps D2 

Short answer: I believe you are going to need to implement this yourself, perhaps repeatedly checking if the due date is impacted by holidays and increment appropriately.

Longer answer:

  • Currently the automation rules do not use the working and holidays configured in projects.  According to the documentation, "business days are considered to be Monday to Friday, 9am to 6pm"
  • There are suggestions to add holiday/working day handling for date functions for automation: https://codebarrel.atlassian.net/browse/AUT-1623 and https://jira.atlassian.com/browse/JIRAAUTOSERVER-186
  • One work-around would be to hard-code (or add as entity properties) the holiday list, and update the date field if it falls between the starting point and known holidays, and increment the business days.  Remember to account for time zones to avoid one-off errors.

Kind regards,
Bill

Hi @Bill Sheboy,

Thanks for replying.

"One work-around would be to hard-code (or add as entity properties) the holiday list, and update the date field if it falls between the starting point and known holidays, and increment the business days. Remember to account for time zones to avoid one-off errors."

Could you please give me more pointers for the aforementioned operation or anything related?

Hi @ED _ DevOps D2 

My apologies as I just discovered I never answered your follow-up question!

My original "short answer" of hard-coding these with repeated conditions, one holiday at a time, appears to be the solution at this point...because...

After experimentation I found that smart value, list filtering cannot use parameters in functions from created variables....And, advanced branching would lead to unpredictable results of doing this one-holiday-at-a-time.  So my suggestion of using entity properties as a list cannot work.

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer