JQL is not returning all issues whithin a data range

Question

Hi Everyone,

I'd like your help in identifying what could be wrong with the following JQL:

project in ("PROJECTS NAMES") AND issuetype = EPIC AND resolved >= 2022-04-01 AND resolved <= 2022-06-31 AND status IN (Closed)

It's not returning one issue resolved in 2022-06-31 and I can't figure out why.

If I change the range to end on "<=2022-07-01", so, the issue with the resolved date in 2022-06-31 appears.

Please, is there something I'm missing?

Thank you in advance.

Julieta.

Trudy P Claspill · Answer

Hello @Julieta Dienstmann

Refer to: https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Resolved

Resolved is a date/time field. If you provide only a date, then the time is assumed to be midnight, according to the documentation.

What I am seeing in practice is that it is implementing that as 12:00 am - the beginning of that date rather than the end of that date.

So when you use

resolved <= 2022-06-31

...you are getting the issues with a Resolved date of 2022-06-31 00:01 am or earlier, which would exclude issues resolved later in the day on 6/31.

This is validated by one of the examples provided in the above document:

* Find all issues that were resolved on or before 31st December 2010:
resolved <= "2011/01/01"

Laurie Sciutti · Answer

Hi @Julieta Dienstmann ~ change the end date portion to exclude the "=" (just <2022-07-01)