Update start and end date and skip holidays

Question

Hi,

I want to update my end date on the basis of the start date and duration in days given, I have achieved it, now I want to skip holidays like 25th Decemeber is the holiday and start date and end date is lies in between this date so add one day more in end date. How can we manage that?

Muhammad Moazzam Hassan · Answer

I have designed this rule, I have use the Lable field because there is not multi-date custom field in Jira, I have added some holidays in the label field in the desired format("yyyy/mm/dd"). I am able to retrieve what is in between and how many holidays occurs in between, but there is silly bug in this for each rule that whether it runs one time or 1000 times it only increments on on whole cycle.

Muhammad Moazzam Hassan · Answer

I knew this solution, but this is not the only objective because the holidays can be multiple in a year, so I want to check the holidays occurs in between start or end date or equals to as well, this solution only solves the equals to query, what if the holidays occurs in between the start date and end  date and more than one holiday occurs in between?

Ste Wright · Answer

Hi @Muhammad Moazzam Hassan

The plusBusinessDays will avoid weekends.

I feel like for holidays, it might be easier to use a separate rule and IF/ELSE statements.

---

For example...

* Trigger: Field Value Changed* Field to Monitor = Planned Start Date

* Condition: IF Block...* IF...* Condition: Issue Fields Condition* Field = Planned Start Date
* Condition = equals
* Date = Specific Date - 25/12/2023

* Action: Edit Issue* Field = Planned Start Date* Value = {{issue.Planned Start Date.plusBusinessDays(1)}}

* ELSE-IF...* ...etc

---

A few notes on this rule...

* If the first rule can trigger the second rule, ensure you allow for this by checking the appropriate checkbox in "Rule Details"
* You'd need to update this rule once yearly if you use static dates. There's alternatives, but some holidays do change date each year also.

---

Let us know what you think!

Ste