Skip to Content

TheBlogReaders.com

Salesforce.com, PHP, MySQL, Javascript, Ajax, Htacces

How to set datetime format in csv file while importing data from CSV to Salesforce Activity Object

Be First!
by October 16, 2013 Data Loader, Deployment, SALESFORCE

How to set datetime format in csv file while importing data from CSV to Salesforce Activity Object (Event/Task)

while importing the activity data from one org to another org using dataloader salesforce tool OR http://dataloader.io/ you need to form the date and datetime value like below format, so that its allow to insert succesfully in the respective object. or otherwise you always getting the below error message

SOURCE: ‘ActivityDateTime’ DESTINATION: ‘ActivityDateTime’ is not a valid DATETIME.[Valid date format: MM/DD/YYYYThh:mm:ss.mmmTimeZone (example: 02/20/1987T12:04:12.000GMT+01:00)].

DATE :  MM/DD/YYYY (Convert as this format)

DATETIME : MM/DD/YYYYThh:mm:ss.mmZ (see the below screenshot)

(3310)

Previous
Next

Leave a Reply