JQL filter for quarter in previous year

[Marcel Jünge]

Hi,

is there a possibility to filter issues that were, for example, created in the second quarter of the previous year?

Thank you,

Best regards,

Marcel

[Hamza Chundrigar · Accepted solution]

Hi Marcel, 

You could use the following JQL to filter out all created issues between April 1 - June 30 (2022)

created >= 2022-04-01 AND created <= 2023-06-30 order by created DESC

Best regards,
Hamza

[Marcel Jünge]

Thank you for your answer. 

To Clarify: I want basically a filter that shows me the issues no matter the year.

Example: Next year i dont want to edit the filter and set the dates to 2023 and so on.

So a filter that shows me now the issues from 2022. Next year it shows me the issues from 2023 without the need to be edited manually. 

I hope you know what i mean. 

[Hamza Chundrigar]

Thanks for clarifying. The filter query I provided used static dates so you would need to edit the filter.

But if the condition is that you would need a JQL query that always takes created issues from the last year's second quarter, then you could use:

created >= startOfYear(-9M) and created < startOfYear(-6M)

 So next year in 2024, it'll show you issues in the second quarter of 2023 (and so on.)

Best regards,
Hamza

[Marcel Jünge]

That is exactly what i wanted.

Thank you very much!!!

[Ste Wright]

Hi @Marcel Jünge 

You can do this, but it's based on either days or dates

So for example, if you mean the second calendar quarter of 2022 you could use either:

created >= startOfYear(-9M) and created < startOfYear(-6M)

OR

created >= 2022-04-01 and created < 2022-07-01

Personally, I think using static dates is easier - but the first option is more dynamic, so wouldn't need to be recreated each year.

Ste

[Marcel Jünge]

I will use the solution from Hamza but thank you very much!

[Ste Wright]

No worries!

Using Month makes more sense. I'll modify my answer to clarify this.

Ste

[Sushant Verma]

Hi @Marcel Jünge 

You can try :

createdDate >= 2022-04-01 and createdDate <= 2022-07-01

Regards,
Sushant Verma