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? :)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.
Learn more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.