Find JIRA older than 4 weeks out of specific created date

[Pramod Maurya]

I would know pull data for below use case

I would like to know list of Jira which are created in Q4 (2024-10-01 to 2024-12-31) AND which are not closed/Done AND which are older than 4 weeks (This one is important)

[Anahit Sukiasyan · Accepted solution]

Hi @Pramod Maurya

Welcome to the Community!

Here’s the JQL query you can use:

created >= "2024-10-01" AND created <= "2024-12-31" AND status not in (Closed, Done) AND created <= -4w 

[Pramod Maurya]

Hi @Anahit Sukiasyan Thank you for the fast response. 

It works great. All I have to do is include this -4w in quote, like "-4w "

[Anahit Sukiasyan]

You're welcome @Pramod Maurya, and I'm glad it worked for you! Yes, adding -4w (with the minus sign) in the query will correctly filter issues that were created more than 4 weeks ago. 

Please accept the answer.

Have a great day!