Issue Query returning incorrectly when using Created > "2020/08/10" still shows 8/10 in the listing

[Linda Wanitschek]

I was going to clean out some issues in a test project.

I wanted to get rid of everything > "2020/08/10"  but the query list has the 8/10/2020 items in it.  It should have excluded those.

I had to use the query with  Created > "2020/08/11" in order to not have the 8/10 items included.

We upgraded our Jira instance recently.   I am afraid if people are going to clean out old stuff, they could end up with bad query selections.

Does anyone know if something changed recently?

[Martin Bayer _MoroSystems_ s_r_o__ · Accepted solution]

Hi @Linda Wanitschek , this behaviour is in Jira for years. I think I used to solve it in Jira 7.0.x for one customer.

The problem here is that created date contains also time part (it is not only date). So condition is evaluated like created > "2020/08/10 00:00"

So your solution fixes it but I would use created > "2020/08/11 00:00" so other people know there is also time part comparison

[Linda Wanitschek]

@Martin Bayer _MoroSystems_ s_r_o__ 

so strange, I have never run into this in the 4 years I have been on Jira.

thanks

Linda