Search Issues by creation date not working

[Manuel Cardoso]

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"

[Manon Soubies-Camy · Accepted solution]

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]

Hi Manon,

Oh, that explains a lot...

Thank you :)

[Manon Soubies-Camy]

Glad it helped :)