function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
aressaress 

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) 
Hi,

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

User-added image

https://help.salesforce.com/articleView?id=Data-Loader-Import-data-for-Date-or-Date-Time-field-1327108684799&language=en_US&type=1
 
Please mark it as solved if my reply was helpful. It will make it available for other as the proper solution.
                                             
Best Regards
Sandhya
 
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
https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/loader_params.htm

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

Data Types Supported by Data Loader​:
https://help.salesforce.com/articleView?id=supported_data_types.htm&type=5&lang=en