Yes this is a big pain when reading any kind of data using excel and it is not dependent on Anaplan The issue is with Excel auto converting dates on file open. There is no way to avoid this behaviour. To keep the date consistent with the way Anaplan formats it, change your system date https://support.microsoft.com/en-gb/help/4026213/windows-how-to-set-your-time-and-time-zone This way when you open a CSV in an excel file, the auto converted date will look correct
Please can you provide more information on the point when you say to change the system date - what to change it to? I am logged in via my company's laptop and it does not allow me to change the Date & Time settings.
Would it be possible for you to share some screenshots of the export view as set up in Anaplan and the date column as it appears after you export it Then I can answer your questions with more confidence!
In order to see exactly what data has been exported in the CSV file, open the CSV file with Text editor ( like Notepad) in order to see exactly what data has been exported from Anaplan to CSV file.
You will notice that by opening the CSV file with Notepad (not Excel), the values is maintained the same was in Anaplan: Jan 20/Feb 20...etc.
Only by opening the same CSV file in Excel, Excel will apply the automatic transformation of the values and data will be transformed. In order to preserve data also in Excel, you can use "Get Data" functionality and specifically define for Time columns to be TEXT type. This way the initial exported value from Anaplan will be maintained.
Excel will always apply some kind of automatic transformations for the values that Excel can recognize as Date or Number.