Date Format conversion

I have a module in Anaplan whose one line item is date formatted. I imported a csv file which is having a date column with the format MM-DD-YYYY. The import results showed a failed report becasue it accepts date format as MM/DD/YYYY. Is there any way to map my csv file having the abovementioned format with the date formatted line item in Anaplan without having to change the date column format in my csv file from - to / ?

Accepted answers

All comments

DavidSmith

@abhay.kanik

Ideally it is best to use a uniform format for all date imports YYYYMMDD which simplifies inputs but it is possible to format import by import

1. On the import, navigate to the mapping tab for the line items and for the date fields you will see on the right hand side a custom mapping check box

2. Click this and the date format dialog appears allowing you to format the date as desired

I hope this helps

David

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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