Date and Time format in CSV to upload on Salesforce
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.
Originally published at https://blog.webnersolutions.com on August 12, 2021.
