Resolution date is greater than the created date by more than 1 day?

John Norman_y5hniy

Hi, I want to exclude all Jira that were created and resolved the same day.  Is there a JQL function where I can search for Jira that were resolved more than one day from the created date?  Can we even search for resolutiondate > createddate?  Any ideas?

Trudy P Claspill

Hello @John Norman 

What type of project is this for; Software, Service, or Business/Work Management?

Service projects have a Time to Resolution value that you could use to in the JQL to exclude issues that took less than a day to resolve. That field is not calculated for other types of projects.

Native JQL does not allow you to compare one field to another as part of the selection criteria. I think that there are third party apps that extend JQL functionality that would provide a work around.

If you are not open to using a third party app, then another work around would be create a custom field, use Automation to calculate the difference between the two dates, and store that value in your custom field. You could then use the custom field in your JQL.