Timedimension while exporting a module in .csv file

Highlighted
Occasional Contributor

Timedimension while exporting a module in .csv file

I am facing an issue when trying to export a module in .csv format.

 

I have setup a Time Range that has 2 Periods and have available aggregations set as Total of All.

 

In a Module I have this Time Range (which is in periods - Jan 20/Feb 20/etc...) in column and when I am exporting the module as a .csv file in the .csv file it reads as 20-Jan/20-Feb,etc...

If I click in the .csv file cell it reads as 1/20/2020,  2/20/2020 which is not correct. Even if I copy from .csv to notepad++  it still reads 20-Jan.

 

In the excel export as .xls it works perfectly fine it reads as Jan 20 in .xls format which is correct

 

Had anyone faced this issue before. How did you resolve it or is it a bug in the current Anaplan version?

3 REPLIES 3
Master Anaplanner/Community Boss

Re: Timedimension while exporting a module in .csv file

Hi,

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

Let me know if you need more help

Regards,
Anirudh
Highlighted
Occasional Contributor

Re: Timedimension while exporting a module in .csv file

Thank you for the reply.

 

Have some further questions:

  • 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.
  • Also, how do you see Anaplan date format?

Thanks!

 

Highlighted
Master Anaplanner/Community Boss

Re: Timedimension while exporting a module in .csv file

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!