Import Date from CSV

Hi,

I want to run a script to update the date on a daily basis. I have a batch file that creates a csv file with header Date and the date underneath on row 2 in format 08-02-2018 also tried 08/02/2018

However i can not import this to a module with a item formatted date, as it will not recognise it as a date , no matter what format i use.

Any suggestions please?

Accepted answers

All comments

Jaakko

Hi,

After selecting the file in the data import, you'll arrive to column mapping menu. Select "Module name line items" tab next to mapping tab. You will see "Custom Mapping" boolean box in the right next to the date formatted line item. Click that and select D-M-Y. It should show the date in your source file and instead of "(ignored)" it should show that it's mapped to 2018-02-08.

Br,

Jaakko

DeveloperCYT

Thanks, but i tried that initally, and unfortunately, none of the formats, including custom ones work.

It simply does not think it is a date... and i am stuck.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385