Incident Creation Time

[Shannon Highers]

Hello,

I need to retrieve the time an incident was created; the created date is no problem. I can view the created time in the lower right-hand corner of each incident, but I am unable to add it to a column or perform a JQL query on it for reporting purposes. 

My Best,

SMH

[Vishal Biyani]

@Shannon Highers 

JQL doesn't support querying based on timezone. Howwever, issue.created is saved in UTC.

As @Mathew Lederman mentioned, you can run JQL like below and since it is stored in UTC irrespective of timezone, you will get the data.

created > '2025-1-1 10:05'

Are you looking at automation to populate a custom field? if so, can you elaborate on the challenge that you are facing.

[David Nickell]

Hello ---

• A disclaimer -- I do a lot of reporting through Power BI (and some excel) outside of Jira.  This gives me the flexibility to format things they way I need.
• The comments so far are correct-- these standard Jira fields have time in UTC format down to the second.
• I don't know if you can parse the datetime fields the way I think you are needing, but there is a potentially expensive solution of using automation to populate a separate tome only field for you
• You might want to check the Marketplace for a solution

Good luck

[Mathew Lederman]

@Shannon Highers the default created field should provide both the date and time an incident was created. If you're seeing relative time (3 days ago) vs absolute time (March 18 at 11:46am) try clicking on the timestamp itself. That should switch you to absolute time. 

As for querying on time, you should be able to use this format within your JQL to call out specific times: 

yyyy/MM/dd HH:mm'

[Samuel Gatica _ServiceRocket_]

Hi @Shannon Highers 

Welcome to the community!

In this video, you will see How to use JQL to search with dates

Example:

• created >= "2024-03-21”

You could easily use the basic functionality to do this as well then switch to “advanced” to see how the JQL would look

Best regards

Sam

[Shannon Highers]

Thank you very much for the tip. I need to report on the time specifically, so I know what time zone customers are opening these cases. It all boils down to resource alignment based on case creation metrics.