How to filter the ticket that was created at last month and this month issue?

Nam Dong Yeon April 11, 2024

Hi I am trying to create the filter which was created at last month and this month at the time when I look up that filter.

Could someone help me?

EX) Lookup time : 2024/04/11

The data that I want : 2024/03/01~2024/03/31 & 2024/04/01 ~ 2024/04/30

2 answers

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 11, 2024

Hi @Nam Dong Yeon 

Please try the startOfMonth() and endOfMonth() functions, perhaps with offsets to test the months you need:

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfMonth--
https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#endOfMonth--

Also, to learn more about creating queries like this, please see this free online training from Atlassian:

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

0 votes
Dexter de Vera
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 11, 2024

Hi @Nam Dong Yeon ,

 

You can try this JQL:

created >= "2024-03-01" and created <= "2024-04-30" ORDER BY created ASC

Just update the date base on your range. 

Suggest an answer

Log in or Sign up to answer