Calculate how many days a issue is open

David Lockhart

I am trying to have a custom field show how many days a issue has been open. I am using the script runner and created a script field. I am trying to find current date - created date for the days open. Here is the script  

import com.atlassian.core.util.DateUtils

DateUtils.getDurationString(((new Date().getTime() - issue.getCreated().date) / 1000 / 3600 / 24 ) as long)

But the date is not showing up correctly. 

 

I also want to exclude issue that are in a closed status here is what i have tried to add 

import com.atlassian.core.util.DateUtils

def Status = issue.getStatusObject();
if (Status == Closed) {
return null;
}
DateUtils.getDurationString(((new Date().getTime() - issue.getCreated().date) / 1000 / 3600 / 24 ) as long)

but it comes back with an error of No such property: Closed for class: Script7* (* this number keeps growing when you press preview). 

 

This is so i can use the field in a gadget on the dashboard. 

Thanos Batagiannis _Adaptavist_

Hi David,

Did you try the similar example in the documentation. First of all the error you are getting is because you misses the quotes in your status comparison, should be

if (Status == 'Closed') {
return null;
}

Also I do not know your exact requirements but I would suggest to use the statusCategory instead of Status. Also in your example, if I move the issue to a Closed status for 3 day and then reopen it, then in your script the result will not be valid (because now the issue is open but it was closed for 3 days)....