Search Issues by creation date not working

Manuel Cardoso May 16, 2022

This seems to be a very simple thing but the results are always different from what I was expecting.

I want to look at issues created between the 1st and last day of a specific month, however, it never returns issues from the last day that I choose.

For example, for issues created starting on the 1st of March and until the 31st of March, it only returns me issues until 30th of March. Tried using the basic search and the JQL, and everything seems to be OK, but the result is always the same - the last day is missing.

On the JQL:

"created >= 2022-03-01 AND created <= 2022-03-31"

1 answer

1 accepted

2 votes
Answer accepted
Manon Soubies-Camy _Modus Create_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 16, 2022

Hi @Manuel Cardoso,

"2022-03-31" is internally translated to "2022-03-31 00:00:00".

So you need to update your JQL query if you want to include issues from 2022-03-31:

created >= 2022-03-01 AND created <= 2022-04-01

Hope this helps!

- Manon

Manuel Cardoso May 16, 2022

Hi Manon,

Oh, that explains a lot...

Thank you :)

Manon Soubies-Camy _Modus Create_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 17, 2022

Glad it helped :)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events