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

Transition date/time field in strange format when exported to CSV

Darren Lowe Nov 09, 2018

I’m hoping someone can help me with a question about a custom field. It’s a “Transition Date/Time Field” from the Jira Misc Custom Fields add-on. It’s configured to automatically populate a date into the field when a transition is clicked on.

This field works great when it’s displayed on the view screen of an issue. However, when I export a group of tickets with this field to a CSV, it displays in a format like this… 22:47.8. 

Is there any way to configure this field to display as a date in excel? Or is there another way to produce a date field that tracks the date when a certain transition(s) is clicked on in a workflow that would display the results as a date when exported to a CSV?

1 answer

0 votes
Darren Lowe Nov 10, 2018

UPDATE: I was overthinking this. It’s just a simple formatting issue. You just have format the column to display a date (right click column header > Format cells > date) and that takes care of it.  

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Marketplace Apps & Integrations

Webinar alert! An IT Admin's Guide to Securing Collaboration at Scale

Hello, Atlassian Community! My name is Dave Meyer and I'm a Principal Product Manager at Atlassian. I wanted to give this community a heads up about an upcoming Webinar that might be of interest...

187 views 2 7
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