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; } } }

JQL for date range

Katrina Atkinson

hello,

I want to create a Jira JQL search for a range of dates but only by month. Instead of the date input of "YYYY/MM/DD" or "YYYY-MM-DD" but instead just MM/DD or MM-DD. Is this possible and does anyone know how to do this?

thanks in advance.

Accepted answers

Alex Koxaras -Relational-

Hi @Katrina Atkinson

You can use the startOfMonth() function to do that. E.g.

created >= startofMonth() and created <= endOfMonth()

Will give you all issue of the current month. Placing a negative number inside the paranthesis will yield results from the previous months. E.g.

created >= startofMonth(-1) and created <= endOfMonth(-1)

Will give you all created issues from the previous month.

All comments

Alex Koxaras -Relational-

Hi @Katrina Atkinson

You can use the startOfMonth() function to do that. E.g.

created >= startofMonth() and created <= endOfMonth()

Will give you all issue of the current month. Placing a negative number inside the paranthesis will yield results from the previous months. E.g.

created >= startofMonth(-1) and created <= endOfMonth(-1)

Will give you all created issues from the previous month.

Katrina Atkinson

Awesome thank you, do you know, if I wanted to do the months between January 01-march 31st how to input this?

Alex Koxaras -Relational-

I would assume:

created >= startofMonth(-11) and created <= endOfMonth(-9)

Katrina Atkinson

This provides a lot of clarity, thank you!

Alex Koxaras -Relational-

Happy to be of assistance

Kindly mark my answer as accepted, in order to help others with similar questions. Thank you!