Automated Data Range in Jira filter?

[Kelli Keith]

If my filter is looking for issues updated during the previous month. For example:

updated >= 2022-02-01 AND updated <= 2022-03-01

Is there a way to automatically make the date range the previous month so I don't have to update it when each month passes?

[Fernando Eugênio da Silva · Accepted solution]

Hey, @Kelli Keith ! Yes, it´s possible.

For that you need to use the following JQL to be something that changes automatically month after month.

JQL: updated >= startOfMonth(-1) AND updated <= endOfMonth(-1)

This JQL is automatically filtering out issues that were updated from the beginning of last month to the end of this same month.

Doc link: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

Best Regards,

Fernando

[Kelli Keith]

Thank you soo much! Does this count the full day of the last day of the month? I had an issue before where I was putting in 2-28, and it was actually not counting anything on 2-28 because it cut off at midnight that morning (the night of the 27th).

[Fernando Eugênio da Silva]

@Kelli Keith 

This counts the full month referenced.

If the action happened within that month and Jira recorded it, this should count normally

[Bill Sheboy]

Hi @Fernando Eugênio da Silva 

I thought the behavior depended upon the fields being compared...

For example, when comparing to just a date field like Due Date, EndOfMonth() would work as you describe...but with a field like Updated that is date/time doesn't EndOfMonth() refer to the start of that day's date/time when it is cast in the JQL?

Thanks in advance for helping me understand this better!

Kind regards,
Bill

[Fernando Eugênio da Silva]

@Bill Sheboy 

If you use this Due Date <= EndOfMonth() scenario Jira will raise questions that the Due Date field value is less than or equal to the end of your current month.

Then, each month will be renewed automatically by the Jira filter.

Let me know if this helps you.

You can also see more details on the Atlassian page: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

If your doubt it´s other, please, tell me ;)