Date format differs while exporting a file in different type of system (eg.MS Excel and Open office)

Options
Richa123
Richa123 Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

Hello,

We have been facing a strange issue while exporting a file from Anaplan in two different systems.

 

The time dimension format differs when we import a file in MS Excel and Open office.

 

Is it true that if we implement a project for a customer everyone in the team should have only one type of system ( either MS excel or Open office )?

 

For example: In the open office it will be the same as Match names 

 

Richa123_0-1632895727641.png

Whereas in MS Excel it MM-DD-YYY

Richa123_1-1632896181867.png

 

 

 

Comments

  • Richa123
    Richa123 Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

    Thank you, Will try this approach.