Jira dynamic search by specific month in year

[mon33h]

Hi,

I am wondering if it is possible to filter a Jira search by a specific month in the year, but having this update dynamically based on the current date. I am reporting on Jiras created in the last financial year, but I don't want to have to keep changing the date in the search - I would like the search to be able to work out the last financial year based on the current date.

For example:

If the current date is anywhere between 1-July-2021 and 30-June-2022, then the query should search between 1-July-2020 to 30-June-2021. Then once the current date ticks over into the range 1-July-2022 to 30-June-2023, the query should search between 1-July-2021 to 30-June-2022.

Thank you

[mon33h · Accepted solution]

I managed to get around this with the following queries, separating by JRs created and JRs closed within the last 5 financial years (from the current date).