Why the date range in JIRA Query is not working accurately

Yi Liang November 13, 2024

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)

1 answer

1 accepted

5 votes
Answer accepted
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 14, 2024

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 November 14, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 14, 2024

yes, you can :)

Yi Liang November 15, 2024

Thank you!

Suggest an answer

Log in or Sign up to answer