Date Time format in CSV to upload on Salesforce

Author - Webner
12.08.2021
|
0 Comments
||

While uploading CSV to create records in Salesforce using workbench. Sometimes we need to upload date-time fields. I have used many formats which were suggested in the Salesforce documentation but none of them works for me. The only format for date-time which works is
YYYY-MM-DDTHH:MM:SS: SSS+GMT

For example, the value of date-time 09/11/2020 and time is 1:00 AM and timezone is IST
The value will be 2020-09-11T01:00:00:000+0530

Webner Solutions is a Software Development company focused on developing Insurance Agency Management Systems, Learning Management Systems and Salesforce apps. Contact us at dev@webners.com for your Insurance, eLearning and Salesforce applications.

Leave a Reply

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