cancel
Showing results for
Did you mean:
See all
See all
##### Groups
Explore all groups

# Calculate date only day of the week

Is it possible to use the runner script to do this?

I need to calculate how many days (day of the week) I need to work to consume all the estimated hours.

Example:
Estimate = 200h
Resource = 2 dev
Time dedicated 4h per day
Start of activity 2/23/2017

200 (estimated hours) / 4 (hours per day) = 50 (days)
50 (days) / 2 (dev resources) = 25 working days

Starting the activity on 2/23/2017, how to add 25 days? (These days being only days of the week (ignoring weekends))

How many days do I have to work to consume these hours?
25 days
What day will I finish work?
I do not know (how to add 25 days only day of week from 02/23/2017?)

1 vote

You could do this with a Scripted FIeld. Most of the real work is just doing some date math using Groovy/Java APIs.

Programmer's warning: Date math is hard. Groovy helps make it a little easier, but I'm still naively assuming there are no holidays, sick days, or other days off in the mix that need to be skipped over, which won't always be the case.

Basically, we'll calculate the total number of days as you do in your pseudo code. Divide that by 5, leaving off the remainder. That's the number of whole weeks, which we can easily add to a date.

The remainder of days need to be carefully looped over in order to skip over weekends.

```import com.atlassian.jira.component.ComponentAccessor
import java.sql.Timestamp

def remainingEstimate = issue.estimate
def numberOfDevs = 2
def millisecondsPerDay = jiraDurationUtils.parseDuration("4h") * 1000

def baseDays = remainingEstimate / millisecondsPerDay
def realDays = baseDays / numberOfDevs
def workingDaysPerWeek = 5

int solidWeeks = realDays / workingDaysPerWeek
int remainingDays = realDays % workingDaysPerWeek

/*
Note: I'm hard-coding the start date here,
but we could make the start date based on a custom field like this:

def customFieldManager = ComponentAccessor.customFieldManager
def startDateField = customFieldManager.getCustomFieldObjects(issue).find{it.name == "Start Date"}
def startDate = issue.getCustomFieldValue(startDateField) as Timestamp

Also, I'm naively assuming that the start date is not on a weekend
*/
def startDate = Date.parse("2017/02/23", "YYYY/MM/dd")
def startDatePlusWeeks = startDate + (7 * solidWeeks)
def endDate = startDatePlusWeeks
def cal = endDate.toCalendar()

if (remainingDays &gt;= 1) {
//Loop through the remaining days, adding one each time, skipping to Monday when it's Friday
(1..remainingDays).each{
if (cal.get(Calendar.DAY_OF_WEEK) == Calendar.FRIDAY) {
}
else {
}
}
}
return cal.getTime().toTimestamp()```

There are some good resources and tutorials on Java & Groovy date/calendar math. They're worth a look if you want to extend the above script to include holidays and such like.

http://www.javaworld.com/article/2074678/core-java/groovy-jdk--gdk---date-and-calendar.html

And, of course, there's always the good ol' GroovyDocs:

http://docs.groovy-lang.org/docs/groovy-next/html/groovy-jdk/java/util/Calendar.html

Using your code I was able to create one that meets my need.
I only have 2 doubts:

1. How do I pass the value of a custom field?
(The Resource and Dedicated field are custom fields in JIRA)

2. What output format do I have to use to be able to use the Data Picker format?
(I'm using the text format to display for now)

```import com.atlassian.jira.component.ComponentAccessor
import java.sql.Timestamp

def remainingEstimate = 200 //(customfield_13902)
def numberOfDevs = 2 //(customfield_14107)
def hourPerDay = 4 //(customfield_14108)
def Date = "23/02/2017" //(customfield_10800)
def startDate = new Date().parse("d/M/yyyy",Date)
def baseDays = remainingEstimate / hourPerDay
def realDays = (baseDays / numberOfDevs) -1
def cal = startDate.toCalendar()
(1..realDays).each{
if (cal.get(Calendar.DAY_OF_WEEK) == Calendar.FRIDAY) {
}
else {
}
}
return cal.getTime().format("d/MM/yyyy")```

Community showcase
Published Nov 27, 2018 in Portfolio for Jira

### Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,541 views 15 21

### Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Connect with like-minded Atlassian users at free events near you!

##### Find my local user group

Unfortunately there are no AUG chapters near you at the moment.