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