Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

JQL to find tickets created between exact time

Tigran Rumyan
Tigran Rumyan October 18, 2021

Hi there ! What I am looking for is to find tickets which were opened yesterday between 19:00-09:00 with JQL

For example 
Today is 18.10.2021 I want to find tickets opened between 19:00 17.10.2021 - 09:00 18.10.2021

Can anyone help? :) 

Answer
Watch
Like Harut Avetisyan likes this
2734 views

2 answers

1 accepted

3 votes
Answer accepted
Thieme Spook
Thieme Spook
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
October 18, 2021

Hi Tigran,

I'm new here as well, but I think this filter will help you out:

created >= startOfDay(-5h) AND created <= startofday(9h) ORDER BY created ASC

 This JQL looks at the start of today - 5 hours, which well go back to yesterday 19.00

The other end of this JQL stops at the start of today till 9.00 of today. 

You can add any other conditions to fulfill your own needs.

View More Comments
Tigran Rumyan
Tigran Rumyan October 18, 2021

Dear @Thieme Spook 

thanks a lot for your support, it works for me !!

Like • # people like this
Reply
0 votes
Kishan Sharma
Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
October 18, 2021

Hi @Tigran Rumyan Welcome to the Atlassian Community! You can use below JQL to find tickets between two dates -

"Start date[Date]" >= 2021-10-17 AND "Start date[Date]" <= 2021-10-18 AND project = XYZ order by created DESC

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events

    See all events