Exporting CSV from Anaplan, incorrect date displays in Excel

Highlighted
Contributor

Exporting CSV from Anaplan, incorrect date displays in Excel

When exporting information into Excel by month it brings the dates through as text, ex  “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for this? (January 2019, will export from Jan 19 to 1/19/19 fyi)

Message 1 of 2
1 REPLY 1
Community Boss

Re: Exporting CSV from Anaplan, incorrect date displays in Excel

Mike,

 

When data is exported to a CSV file from Anaplan, dates are actually being exported.  If these are not showing properly, I would look into your regional settings on your computer.

 

I found this on google for a Mac:  https://resrequest.helpspot.com/index.php?pg=kb.page&id=277

 

I found this on google for Windows: https://www.google.com/search?ei=XHdTXJjyOo7ktQWOlrX4Bg&q=excel+regional+settings+windows+10&oq=exce...

 

Hope this helps and let us know if you are still having this issue.

 

Rob

Message 2 of 2