+ Start a Discussion

data loader date time

I want to insert 2000 record using dataloader,In the CSV file there is a date field whose format is dd/mm/yyyy
I want to insert record in an org whose locale is Los Angeles, USA. date format (yyyy-mm-ddThh:mm:ss.000Z)
How can i convert the date so that record are inserted succesfully
SandhyaSandhya (Salesforce Developers) 

You may  open your csv file in excel, select the date column, then change the formatting.

User-added image

Please mark it as solved if my reply was helpful. It will make it available for other as the proper solution.
Best Regards
Alain CabonAlain Cabon
There is an option : set the following in the process-config.xml file.

<entry key="process.useEuropeanDates" value="true"/>
  • process.useEuropeanDates  = boolean = Use European date formatSelect this option to support the date formats dd/MM/yyyy and dd/MM/yyyy HH:mm:ss.  Sample value: true

A sample process-conf.xml file is in the \samples\conf directory that’s installed with Data Loader.

Data Types Supported by Data Loader​: