Jira Server Scriptrunner: Set Due Date based on Custom Field Selection, Excluding Weekends

Megan D

What I need:

A due date to be auto-filled based on what custom dropdown field already says, but to also account for our weekend.

Dropdown selection is:

Request Complexity: (custom field: 14220)

• Simple (3 days)
• Average (7 days)
• Complex (14 days)

The days in italics (above) are how much time to add to the current date for the due date.

Due Date (custom field: 14233)

• Needs to account for the weekend (ours is Friday-Sunday).
  • Example: if a user starts this process on a Thursday, and the request is a "Simple" complexity, it would actually be due on Tuesday since we "skip" Friday-Sunday.

What I have:

This is my current code, but it doesn't account for the weekend, but it also doesn't work as-is. I would greatly appreciate any help or code you can provide. Thank you!

import com.atlassian.jira.component.ComponentAccessor
import java.text.SimpleDateFormat

def customFieldManager = ComponentAccessor.customFieldManager
def duedate = customFieldManager.getCustomFieldObjects(14233)

def complexityField = customFieldManager.getCustomFieldObjects(14220)
def complexityFieldValue = issue.getCustomFieldValue(complexityField).value.toString()

def dateFormat = new SimpleDateFormat("d/MMM/yy")
def duedateValue = dateFormat.parse(issue.getCustomFieldValue(duedate).toString())

if(complexityFieldValue == "Simple"){
    duedateValue + 3} 
else if(complexityFieldValue == "Average"){
    duedateValue + 7} 
else if(complexityFieldValue == "Complex"){
    duedateValue + 14}

 

Tuncay Senturk _Snapbytes_

Hi @Megan D 

First of all, I must admit I'm a bit envious that you have 3-day weekends including Fridays

Below, I tried to write some code/functions that could provide some help, please be aware that I haven't tested the code, this is just a sample code that might help you achieve your goal.

// function which return how many days it should add based on the selection of the complexity custom field.
def daysToAdd
   if (complexityFieldValue == "Simple") {
      daysToAdd = 3
   } else if (complexityFieldValue == "Average") {
      daysToAdd = 7
   } else if (complexityFieldValue == "Complex") {
      daysToAdd = 14
   } else {
      return
}

// function that finds the final datetime adding n-days
def addDaysExcludingWeekends(startDate, days) {
   Calendar cal = Calendar.getInstance()
   cal.setTime(startDate)
   while (days > 0) {
     cal.add(Calendar.DAY_OF_MONTH, 1)
     if (cal.get(Calendar.DAY_OF_WEEK) != Calendar.FRIDAY &&
       cal.get(Calendar.DAY_OF_WEEK) != Calendar.SATURDAY &&
       cal.get(Calendar.DAY_OF_WEEK) != Calendar.SUNDAY) {
        days--
     }
   }
   return cal.getTime()
}

// calculated dueDate
def dueDate = addDaysExcludingWeekends(currentDate, daysToAdd)

// update the issue
issue.setCustomFieldValue(duedateField, dueDate)

 I hope it helps!

Best!