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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • 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

Jira Cloud - How updating Date Time format affects the existing values?

Hi!

We have a number of custom fields tracking different timestamps of an incident's life. For example - Incident Started Timestamp is one of the fields. One of the uses is to calculate the incident duration, but since the default timestamp format of Jira is MMM dd, yyyy HH:mm, we cannot track incidents that occur only for a few seconds. 

I'm planning to adjust the format to MMM dd, yyyy HH:mm:ss to allow us to track seconds as well, but my question is - 

How would this affect all the values in existing tickets which don't have the seconds. Would it append :00 at the end of all values or would the values become invalid? (We have thousands of tickets already in Jira and I don't want to mess up any existing data.)

Thank you, in advance! 😄

(Apologies for the long rambling, but I thought it best to provide the background.)

1 answer

1 accepted

1 vote
Answer accepted
John Funk Community Leader Jan 26, 2021

Hi @Shahroz Naeem ,

Try using Automation For Jira to calculate the difference in the fields. You would need another custom field to hold the value - also a date/timestamp type of field. Something like Incident Duration. Then to calculate the value when less than a day, use something like:

{{[date1].diff([date2]).[unit]}} where the unit is seconds or minutes

So, {{issue.incident started.diff(issue.incident ended).seconds}}

Or you can use the custom field id like this:

{{issue.customfield_10015.diff(issue.customfield_10016).minutes}}

Hi @John Funk
Thanks for the response! I already know that part. What I'm worried about is if changing the global date format would simply append the extra data to existing value or if something else might happen.

John Funk Community Leader Jan 27, 2021

Sorry - did not read your question all of the way through before. Yes, it would just append :00 to the end of existing issues. 

Like Shahroz Naeem likes this
Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira

Announcing the waitlist for Jira Work Management

Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...

874 views 14 20
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