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

Excluding Saturday and Sunday in Scriptrunner

Prashant Hiremath October 8, 2018

Hello All,

We are using Script runner for JIRA to achieve following functionality:

We have three custom fields:

Start Date(Date/Time picker)

End Date(Date/Time Picker)

No. of Days(numeric type)

Upon selection of Start Date and No. of Days, End Date should be automatically calculated and displayed. I have implemented this functionality.

As an additional requirement, I am unable exclude Saturday and Sunday for being calculated in the End Date.

Since Saturday and Sunday are non-working days,  I want the script to exclude Saturday and Sunday and then display the End Date.

Kindly help me with the script correction.



Following is the script:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue

Issue issue = issue
def customFieldManager = ComponentAccessor.getCustomFieldManager()
//Custom field defined for No of days
def daysToAddCF = customFieldManager.getCustomFieldObjectByName("Number of Days")
//custome field for defining Start Date
def dateACF = customFieldManager.getCustomFieldObjectByName("Start Date")

def dateAValue = issue.getCustomFieldValue(dateACF) as Date
def daysToAdd = issue.getCustomFieldValue(daysToAddCF) as int
def dateB = Calendar.getInstance()

return dateB.getTime()


0 answers

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events