Changing date formats while importing into modules

I am building intermediate module. While importing data into Rep Setup module the Start Date and End Date are formatted as DD/MM/YYYY instead of MM/DD/YYYY. How to change this? I observed that in excel it is in MM/DD/YYYY format and there is no option to change format in Line Items formatting or while importing

123_1727.png

Accepted answers

All comments

PrevContributor

Hi Ravi,

You can solve this by changing your browser settings:
https://www.swansea.ac.uk/media/ABW General Guide - CHANGING INTERNET BROWSER DATE FORMAT SETTINGS.pdf

If you put it to American format, you should be doing fine.

Best regards,
Jethro van der Veer

tbeck

Here is a solution to update the formats using the import process to a module, using a coded flat list and custom mapping the date format to Anaplan, based on the date format in the Import File.

I have attached a file with screen shots to give a visual representation of the steps below.

1) Create a Flat List that you will import as Code:Code to reference in the Module you wish to import, if a specific list is already in place you are using to Reference the date, ignore this step and Apply the List to the Module you desire to change the date formats to.

2) Create a Module using the Specific List in Step 1 in the Applies to, and have your date(s) as line items for the import, Formatted as "Date"

3) Import the Data using your CSV file or TXT file, by selecting Data > Import > Upload New File > Select File then map the Column with the Date in your file to the Line Item Formatted as "Date" in your Module.

4) MAPPING: Map your Source Code to the File's Column containing the Code, and your Date Format to the Column(s) containing the Dates, or in this case "Column Headers"

5) FLAT LIST MAPPING: If your codes are mapped correctly, they will be automatically mapped to to the File as they are coded in the Flat List

6) MODULE LINE ITEM MAPPING: When you map your Line Items, there will be an option for "Custom Mapping" in the Boolean selection to the right of the Target Items; Check the box and custom map your date formats.

7) CUSTOM MAPPING: Select the Format of the Input, and Anaplan will automatically recognize the format to map for the import as shown below in each Date Format Type:

😎 Import the data into the module and recognize the format of the Date is automatically changed to the standard date format.

Date_Format_-_Import_Process_Using_Custom_Mapping_Option_44344.xlsx

tbeck

Here is a solution to update the formats using the import process to a module, using a coded flat list and custom mapping the date format to Anaplan, based on the date format in the Import File.

I have attached a file with screen shots to give a visual representation of the steps below.

2) Create a Module using the Specific List in Step 1 in the Applies to, and have your date(s) as line items for the import, Formatted as "Date"

4) MAPPING: Map your Source Code to the File's Column containing the Code, and your Date Format to the Column(s) containing the Dates, or in this case "Column Headers"

5) FLAT LIST MAPPING: If your codes are mapped correctly, they will be automatically mapped to to the File as they are coded in the Flat List

7) CUSTOM MAPPING: Select the Format of the Input, and Anaplan will automatically recognize the format to map for the import as shown below in each Date Format Type:

😎 Import the data into the module and recognize the format of the Date is automatically changed to the standard date format.

Date_Format_-_Import_Process_Using_Custom_Mapping_Option_44345.xlsx

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