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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.