Calculate the time issue have been created without holidys

Harry Huang_fv30x7

Hi gus,

 

I want a field to calculate the time issue have been created without holidys (saturday&sunday).

But I don't kown how to do it.

 

Below is my code, but it is include holidays.

How can I  except holidays?

 

def haveBeenCreatedTime = System.currentTimeMillis() - issue.created.getTime()
return (haveBeenCreatedTime / 1000 / 3600 / 24 ) as long 

 

Mohamed Adel

@Harry Huang 

 

You need to use a another method to calculate the the non-working days between your start/end date then deduct the return value from "haveBeenCreatedTime"

 

in your case startcalTime = System.currentTimeMillis() , endCal = issue.created.getTime()

 

def countNonWorkingDays(def startcalTime, def endCal) {

    Calendar startCal = new GregorianCalendar()
    startCal.setTimeInMillis(startcalTime)
def iHolydayCnt = 0
    while (startCal.getTimeInMillis() < endCal) {
if ((startCal.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY)
            || (startCal.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY))
        ) {
            ++iHolydayCnt
        }
        startCal.add(Calendar.DAY_OF_YEAR, 1)
    }
return iHolydayCnt
}