search date range between specific days of unspecific months

Question

Hi folks,

I need some help with a search. I know that I can use startOfMonth() and endOfMonth() to search tickets in this range. But what I need is a search between the 28th of a months and the 27th of the next months. So to speak my month will start on the 28th and not on the 1st and will end on the 27th and not on the 30th.

For example:

Issues created between 28.07. and 27.08.

But I will not have to change my query every month as I will need the same query again for the 28.08. - 27.09. and so on.

I hope this is quite understandable.

Tarun Sapra · Answer

Java 8 time features (this will work in groovy as well)

https://www.baeldung.com/java-8-date-time-intro

Tarun Sapra · Answer

Since the duration of month also varies (30, 31, 28 or 29 (leap year) days) thus hardcoding the days won’t always work

Scripting seems to be the possible solution

Please see here how to write an custom JQL function

https://scriptrunner.adaptavist.com/latest/jira/custom-jql-functions.html

Or a custom JQL plugin

https://developer.atlassian.com/server/jira/platform/adding-a-jql-function-to-jira/

unknown · Answer

Hi @Julia Zastrow [demicon],

I will shout out to the other Champions to see if they know of a method to achieve your requirements.

Apologies I cannot be any further assistance directly.