Excluding Saturday and Sunday in Scriptrunner

[Prashant Hiremath]

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.

Regards,

Prashant

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

dateB.setTime(dateAValue) 
dateB.add(Calendar.DATE,daysToAdd)
return dateB.getTime()