nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL Compare Dates - Created vs. Updated

Martin Schmid1

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

Accepted answers

Renjith Pillai

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

All comments

Jobin Kuruvilla [Adaptavist]

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

BlueKai Support

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.

Renjith Pillai

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

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.

Jens Kisters __SeibertSolutions

Script Runner has a date compare JQL Function

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira