Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to calculate the number of days the issue is in a particular status?

Hi Team,

I need to calculate the number of days the issue was in particular status. I checked the below link, but it is showing the result in format of weeks, days, minutes..


I am using Script runner plugin. Could you please help me in getting number of days as a integer value in the field

1 answer

1 accepted

0 votes
Answer accepted

Hi @Suvidhaa Subramani 


Please check Script runner library. IMHO this can be helpful -





Hi @Sebastian Krzewiński 

This code returns the time in Week, days format.

my requirement is to have only number of days.

For example,

If the total time in that particular status is 10 days, then the code is returning 1W 3D

But I am expecting 10 in the field

Could you please help me

@Suvidhaa Subramani as I see script return time in seconds. What I see from your example is that Jira is converting time to this format. Please check type of your field and see this doc how to fix this -




I changed my duration field to number field and converted the milliseconds answer to days. It worked

Like Sebastian Krzewiński likes this

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events