Apex Code Development You need to sign in to do that
Don't have an account?
aress 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
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
You may open your csv file in excel, select the date column, then change the formatting.
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
<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.htmA 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