You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?