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)
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.