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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.