nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automated Data Range in Jira filter?

Kelli Keith_s3kzq6

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?

Accepted answers

Fernando Eugênio da Silva

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

All comments

Fernando Eugênio da Silva

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_s3kzq6

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud