JQL Compare Dates - Created vs. Updated

Martin Schmid July 18, 2012

Hello,

is it possible to compare two dates (Created - Updated) with a JQL Query. I would like to know the average duration of an Issue!

Best regards,

Martin

4 answers

1 accepted

3 votes
Answer accepted
Renjith Pillai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 20, 2013

Average Duration of an Issue is available in "Average Time in Status" gadget.

And for getting days between dates, use script runner and add a scripted field which can get the difference between Created and Due dates.

def diff = new Timestamp(issue.getDueDate().getTime() - issue.getCreated().getTime()).getTime()
def days = (int)(diff/ (1000 * 60 * 60 * 24)); 
return days

Renjith Pillai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 20, 2013
Typo: need to do diff between custom fields that get updated using post functions. Or use issue history and get the statuses' transition date and give the difference.
3 votes
Jens Kisters //SeibertSolutions
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 24, 2016

Script Runner has a date compare JQL Function

1 vote
BlueKai Support January 20, 2013

anybody find a good way to do this? We're trying to report stories that are late by comparing a due date with release date.

A custom field with that does the day difference would be great. Anybody have ideas?

thanks.

1 vote
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 18, 2012

You can't do this with a JQL query. Write a custom report or see if there are any existing ones in marketplace.

Suggest an answer

Log in or Sign up to answer