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

[Nam Dong Yeon]

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

[Bill Sheboy]

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

[Dexter de Vera]

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.