How would I find a ticket Created in the previous month and closed in a different month by JQL?

[Gajanan Sasane]

I want to find all the issues created in the previous month and closed in a different month by JQL.

[Zoryana Bohutska _SaaSJet_]

Hi @Gajanan Sasane 

Optionally, when you don't know how to build JQL, you can try to use Dynamic Filters: JQL Replacer for Jira. Choose the date ranges you need (as shown on the screen below), and you'll get the list of issues you are searching for. 

Regards

[Moses Thomas]

Hello Sisane,

As  i  understand you want a query to show issues  that will be resolved in the future

created > startOfMonth(-1) AND resolutiondate >= startOfMonth(0)

created > startOfMonth(-1)    gives ticket created in the last month

resolutiondate >= startOfMonth(0)  give ticket where resolve starting  in the current  and above

I  hope it helps.

Kind regards,

Moses

[Brijesh Pathak]

Thanks Moses, it helped me with my query.

with your query it was giving me all tickets starting previous month till date (includes current month as well)

Below query help me getting data only for previous month

"created > startOfMonth(-1) AND created < endOfMonth(-1)"

Thanks

Brijesh