AnsweredAssumed Answered

TBC Date format changes when exporting to Excel

Question asked by Brent R on Sep 27, 2016
Latest reply on Sep 30, 2016 by Chris Warren

When I import data points into TBC v3.61, everything looks good with attribute information. However, when I export to Excel 2010 (.csv), the date attribute changes from 9/27/2016 to being separated into three columns and appears as Tuesday    September 27    2016. This never happened when I was using TBC v3.0 and after I upgraded to v3.61, I noticed this issue. I have tried a few different settings within TBC and Excel but nothing worked. I need the date to stay the same as the original entered date, after it is exported to .csv. Is there a fix for this?

 

any suggestions is much appreciated...thanks

Outcomes