nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automatically set expected Due Date to issue, exclude weekends and holidays

Vrushali Hasbe

Hi everyone

I am trying to update my expected Due Date from the Created Date.(Created date+5)
I want to exclude weekends (Saturday and Sunday) when calculating the Expected Due Date.
Is there any way to Calculate due date except Saturday, Sunday and holidays??

Accepted answers

Antoine Berry

Hi @Vrushali Hasbe ,

This should be of good help.

Antoine

All comments

Andrew_g4chs4

Hi @Vrushali Hasbe ,

I suppose resolution depend which plugin You are using.

B.R.

Vrushali Hasbe

Hi @Andrew

I am using Scriptrunner plugin for Jira plugin.

And also I have tried script that I have found online but it do not work for me.

I want to set due excluding Saturday and Sunday and public holidays

Suppose Today i have created one issue then my due date will be current date+2.
If i create issue on Friday means my due date will be (current date+2) but excluding Saturday and Sunday. means the date present on Tuesday.

Antoine Berry

Hi @Vrushali Hasbe ,

This should be of good help.

Antoine

Vrushali Hasbe

Hi @Antoine Berry

Thanks for the solution.

I have use your solution also But i can't able to update due date for issue and also my Due date custom field is present on view issue screen. I have attached the screenshot. please check it and tell me where i am wrong.

Due Date post function1.jpg Due Date Post Function.jpg Due Date Issue.jpg

Antoine Berry

Hi @Vrushali Hasbe ,

Please use this script :


Calendar c1 = GregorianCalendar.getInstance();
c1.setTime(new Date())

for(int i=1;i<=5;i++){
    c1.add(Calendar.DAY_OF_MONTH, 1);
if (c1.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY)
        c1.add(Calendar.DAY_OF_MONTH, 1);
if (c1.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY)
        c1.add(Calendar.DAY_OF_MONTH, 1);
}

c1.clearTime().getTime().toTimestamp()

Antoine

Vrushali Hasbe

hii @Antoine Berry

Thank you very much for your script and it is working fine for me.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server