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; } } }

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.

Accepted answers

Alexis Robert

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

All comments

Alexis Robert

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

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

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.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management