Should I get results when using the = operator for resolved or resolutiondate

[Tom Brown]

Hi,

It has just been brought to my attention that JQL such as resolved <= 2023-09-06 do not return any issues that have been resolved on 2023-09-06 (there have been), only those issues resolved prior to 2023-09-06.

Similarly if I try resolved = 2023-09-06 (or for any other date) then I get no results even though I can see that issues have been resolved on the dates specified.

However if I use resolved >= 2023-09-05 then this includes all issues resolved on 2023-09-05 (as expected) as well as those greater than that date.

Does anyone else experience this problem or can explain the logic for why <= or = operators do not work for resolved or resolutiondate.

I have tried similar searched using due and duedate and these all work as I would expect.

Thanks,

Tom

[Kseniia Trushnikova · Accepted solution]

Hi @Tom Brown,

Here's the thing. Dates in JQL are transformed in date time values. The JQL resolved <= 2023-09-06 is the same as resolved <= "2023-09-06 00:00".

There's a known bug created about such JQL behavior: https://jira.atlassian.com/browse/JRASERVER-45226 It's relevant for all date fields, not only resolution dates.

[Tom Brown]

Thanks for the explanation and link, not how I would expect the operator to work for date queries but explains what is going on.