JQL Does not show resolved by specific date. But does for date range.

[dave]

I am trying to have JQL that reflects what was "closed" on a specific date

ie: project = "Test" AND resolved = 2021-03-29

I get "No issues were found to match your search"

However, if I search for a range that includes the above date I can see there are issue(s) on that date.

project = "Test" AND resolved >= 2021-03-28 AND resolved <= 2021-03-31

What's the deal?

[Walter Buggenhout · Accepted solution]

Hi @dave,

I think the reason is that resolved is actually a Date/Time field. I did a small test in a local instance to notice that the following statement did not return any results, as you describe too:

Resolved = 2021-04-06 

I did locate an issue that had 2021-04-06 09:50 as resolution date. But the database is even more precise, so I needed the following statement to locate this one issue:

resolved >= "2021-04-06 09:50" AND resolved <= "2021-04-06 09:51"

[dave]

That does work @Walter Buggenhout , thanks. But that is a pita to keep updating.