nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Why the date range in JIRA Query is not working accurately

Yi Liang_2068pm

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)

Accepted answers

Sebastian Krzewiński

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

All comments

Sebastian Krzewiński

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_2068pm

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_2068pm

Thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud