Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL for time range

For the past 1 year I need to find the number of issues created in different time range say between 2 am to 3 am, 3 am to 4 am and so on....

So the ask here is to find issue created based on time range.

What will be the JQL for that?

1 answer

1 accepted

2 votes
Answer accepted

Hello @Manish Sonowal 

Welcome to the community.

I don't believe there is a JQL that can be used in the Free JIRA Cloud version to get you this information.

I don't work with the Free version, so I'm not sure about what you can do to augment it with regarding to adding apps or customizations. One customization you could investigate is adding a custom field to track the hour of the day when an issue was created, and seeing if you can set that field for each issue using the Automation feature to evaluate the Created date/timestamp.

Hi @Manish Sonowal  -- Welcome to the Atlassian Community!

Agreeing with @Trudy Claspill there is no built-in way to do this with JQL...And if you just need this one time, I suggest exporting the data to a spreadsheet to report this by parsing the time out of the Created field.

Best regards,


Like Manish Sonowal likes this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

New Cloud Apps Roundup - Spring 2021

Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...

84 views 1 12
Read article

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