function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Joel Kikkert 23Joel Kikkert 23 

How to set Salesforce DateTime Format in Excel

Hi, 
We're migrating data and I need to set the audit fields with created date which is a datetime format field. I tried everything but it just errors out on me. My current format is: mm/dd/yyyyThh:mm:ss".000GMT+01:00" 
However, this one won't work for me. Anybody knows the right format and has an example on how to set this in formatting in Excel?

Thanks
Joel Kikkert 23Joel Kikkert 23
Hi Sura, I saw the article before. I managed to solve it formatting Excel using the following custom format: yyyy-mm-ddThh:mm:ss".000Z"
Just apply it the the cells and you'll be able to push dateTime
Arvind KumarArvind Kumar

Hi Joel,

Yes, You must use YYYY-MM-DDThh:mm:ssZ custom date format in excel.

Thanks,
Arvind Kumar

Harshit Garg 6Harshit Garg 6
HI Joel,

You can use Arvind solution because of the same format already I have used.

If You want to understand deeply. Please read the below link. It would very helpfull for you.

Link - http://fullcircleinsights.com/excel-datetime-formatting-for-salesforce-imports/

Thanks,
Harshit Garg
Asi Avrahami 9Asi Avrahami 9
In Excel!
Choose the date/time columns (make sure you have 2 free columns to break the date and time into)
Click on Date tab, Text to Columns
Convert the text, I use custom character "T"
You will get 2 fields with Date & Time
Julio NhiukJulio Nhiuk
The AZ-900 exam (https://dumpsboss.com/microsoft-exam/az-900/) is a crucial step in building your career in the field of Microsoft Azure. It tests your knowledge and understanding of cloud concepts, core Azure services, security, privacy, compliance, and trust. But what can you expect when you sit down to take this exam?