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)

Written by 

I am Sakthivel Madesh, a certified Salesforce Advanced Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 15x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead 5x Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply

Your email address will not be published. Required fields are marked *

*