Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL Query - Search Tickets

Is it possible to filter tickets with the following conditions please?


Tickets from
Date: 01/08/2018 (dd/mm/yyyy) to 01/05/2022 (same date format as the latter).

Time: all tickets opened after 17:00 or 17:30.


Can these conditions be applied for a full period, and if possible with time as those are the specifics needed?


If not would a different jql query be possible using time as this is the most important requirement rather than date?

1 answer


Jira supports below date formats only. 

Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.


You search as below 

created >= "2022/05/10 17:00"

WOuld prefer the specific jql query if possible. Search for tickets from 01/08/2018 - 05/05/2022 17:00 - 23:59

Hi @Novum Bank Limited ,

Do you mean, you want the tickets created between 5 P.M and 11:59 only for all these days?

Exactly. If not possible maybe there is a way to do them month by month


Luke Brincat

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you