How do I find issues created and closed in the same month?

[Gajanan Sasane]

I want JQL to find all the issues which are created and closed in the same month.

Thank You.

[Alexis Robert · Accepted solution]

Hi @Gajanan Sasane , 

you can use the following JQL to find issues created and closed in the same month : 

project = XXX AND (created >= startOfMonth() and created <= endOfMonth()) AND (resolutionDate >= startOfMonth() and resolutionDate <= endOfMonth())

Let me know if this helps, 

--Alexis

[Zoryana Bohutska _SaaSJet_]

Hi @Gajanan Sasane 

Optionally, you can consider the solution Dynamic Filters: JQL Replacer for Jira (created by my team). It lets create difficult requests for filtering issue lists without JQL knowelage. 

[Joseph Chung Yin]

@Gajanan Sasane -

As stated by @Alexis Robert JQL - You can also use the field "resolved" instead of "resolutionDate" in the JQL to get the same results.  NOTE - "resolved" and "resolutionDate" are populated when an issue's "Resolution" field is set at WF's terminal status.

Best, Joseph Chung Yin