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; } } }

Jira tickets filtering by date range

Tian Hong Tok

Anyone having similar issues?

If i want to filter tickets by date range from say 19Nov2021 to 25Nov2021

the result would only show 19nov to 24nov, it would not show results for 25nov.

it seems like the end time for this filter is 00:00 hr instead of 23:59hr on day 25nov

why is this so ?

regards.

Tok

Accepted answers

Brant Schroeder

@Tian Hong Tok Per Atlassian's documentation "Search for issues that were created on, before, or after a particular date (or date range). Note that if a time-component is not specified, midnight will be assumed. Please note that the search results will be relative to your configured time zone (which is by default the Jira server's time zone)."

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/

I would suggest just using the >= and <= operators.

All comments

Brant Schroeder

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/

I would suggest just using the >= and <= operators.

Tian Hong Tok

There's no field for specifying time. And its a default GUI for Jira.

I guess this is a bug? If its a bug, should it be fix ?

jira gui search bug.JPG

Brant Schroeder

@Tian Hong Tok I believe that the basic selector is already using it. You can check by going to advance search to confirm.

Tian Hong Tok

@Brant Schroeder You looking at this attached screenshot, date selected <=25 nov, that means all 25th Nov tickets should appear but it is not. selection 1 - not selecting last day.JPG

Now, adjusted the selected to pick <=26 Nov, then all 25 Nov ticket appears. So it had nothing to do with time selected which is not present in the GUI selector.

selection 1 - not selecting last day -B.JPG

Brant Schroeder

@Tian Hong Tok looks like you have the solution to get the issues you want in the results.

Serhii Kibitkin_SAASJet_

Hello Tian

I tried the following option using JQL constructor add-on.

function - endofDay (-1d) for test date Nov. 29th

I use this add-on - Dynamic Filters: JQL Replacer & Gadgets

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management