Incident Creation Time

Question

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_2pr07j · Answer

@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.

Shannon Highers · Answer

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.

David Nickell · Answer

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