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

[Brant Schroeder · Accepted solution]

@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.

[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

[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 ?

[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. 

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. 

[Brant Schroeder]

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

[Tian Hong Tok]

@Brant Schroeder this is a workaround , but its clearly a bug and hope that Atlassian could fix it. 

[Brant Schroeder]

@Tian Hong Tok You can submit a bug or enhancement request here: https://jira.atlassian.com/secure/Dashboard.jspa