Jql query to find issues between created and completion date

[Deleted user]

I want to find out list of issues between created and completion date. How to write query for the same?

[Walter Buggenhout]

Hi @[deleted],

Could you be more specific about what you are trying to achieve with your search? JQL out of the box is not capable to compare different issue fields.

You can search for issues where both fields help you narrow down the result set. The below example would retrieve all issues that were created after the start of previous month and completed in that same month.

created >= startOfMonth(-1) and resolved <= enOfMonth(-1)

 I'm not sure from your question though what you would like to see as the actual result of your search.

Hope this helps!

[Deleted user]

Thanks for responding @Walter Buggenhout . Can you let me know what is the JQL query to find out list of issues for previous sprint?