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

Question

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 Answer

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"