Why the date range in JIRA Query is not working accurately

[Yi Liang]

Hi All,

I found an issue of using the JIRA query within the date range.

I got different numbers in the following query.

Any idea to the possible reasons?

1) issuetype in (Bug, Feature) and (resolved >= 2024-07-01 and resolved <= 2024-09-30)

2) issuetype in (Bug, Feature) and (resolved > 2024-06-30 and resolved < 2024-10-01)

[Sebastian Krzewiński · Accepted solution]

Hi @Yi Liang 

Reason is field type. Resolved field is date/time type so if you put date only it automatically set 00:00 time. In your case:

• resolved >= 2024-07-01 means show me all tickets higher or equal to 2024-07-01 00:00
• resolved > 2024-06-30 means show me all tickets higher to 2024-06-30 00:00 which will show all tickets from 2024-06-30 00:01

Regards,

Seba

[Yi Liang]

Hi @Sebastian Krzewiński ,

Thank you so much for answering my question.

Can I add the time after the date in above JIRA query?

like “resolved >=2024-09-30 23:59”?

[Sebastian Krzewiński]

yes, you can :)

[Yi Liang]

Thank you!