Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Exporting reports out of Portfolio converts dates to epoch time

Each month I export a report out of Portfolio that includes dates generated by Jira for Being Developed, Done and Deployed.  These represent when the card was moved to the corresponding column on our sprint board.  This month, when I exported the data, I noticed that those three fields are not exporting the same as they usually do.  Now, they are being converted to epoch and look like this: 1.53511E+12.  It's a number so large that Excel is unable to convert it to a date.  We also utilize fields that are just in Portfolio for Target Start and Target End.  Those export to Excel as expected. 

I found a formula that converts the dates back to 'mm/dd/yyyy' format in Excel, but I'd like to not have to do that.  

Has anyone else experienced this problem?

1 answer

1 accepted

0 votes
Answer accepted
Roi Fine Atlassian Team Nov 14, 2018

Hi @Jovanna Pugh


This sounds like a bug to me, please contact support and submit a ticket here:


I hope that helps,

It does help, and I will submit a ticket.  Thank you!

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events