You need to sign in to do that
Don't have an account?
Joel 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
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
Just apply it the the cells and you'll be able to push dateTime
Hi Joel,
Yes, You must use YYYY-MM-DDThh:mm:ssZ custom date format in excel.
Thanks,
Arvind Kumar
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
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