Import Issues with date and time format in CSV

Highlighted
New Contributor

Import Issues with date and time format in CSV

Hi everyone, I am trying to import data from CSV file. However, whenever I try to modify the data and save the file with CSV format the Date and time format in CSV automatically changed to its original format. Our Anaplan models cannot recognize the original CSV format, so I have to re-input it.

Can anyone help me to solve this problem without re-inputting the date format?

 

Thank you.

Warren

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Import Issues with date and time format in CSV

@Ha Linh 

 

It is possible to customise the time mapping in Anaplan import actions.This way you do not have to edit the csv file each time.

 

If importing into a module lookout for this option:

anirudh_0-1587100623483.png

 

And if importing into a list, lookout for this option

anirudh_1-1587100672517.png

 

Check that box and edit the mapping to suit your requirement

anirudh_2-1587100706112.png

 

 

Let me know if you need more help

 

Regards,

Anirudh

 

Highlighted
New Contributor

Re: Import Issues with date and time format in CSV

@anirudh Thank you very much!!!