You need to sign in to do that
Don't have an account?
RLouden
Importing Date Data Failure
Hi, I can't get Salesforce to import dates. I did my trial import and 5 out of 6 date of births failed. I have changed the excel formular to be the same as the help and training format of:
m/d/yyyy h:mm AM/PM
but still have issues.
Any help would be VERY appreciated!
Thnaks!
If you're using the import wizard, try your organizations default locale standard date or datetime format. (Should match the form display format)
eg.
US/English
06/25/2010 12:00:00 AM (DateTime)
06/25/2010 (Date)
If you're using the data loader, try the system date/datetime format:
eg
1999-01-01T23:01:01+01:00 (DateTime)
1999-01-01 (Date)
Yes, it's important to check EXACTLY your locale setting format for your specified locale, particularly if you are importing a full date and time stamp field. You can check your specific setting in the sf.com documentation here.
https://na8.salesforce.com/help/doc/user_ed.jsp?section=help&target=admin_supported_locales.htm&loc=help&hash=topic-title
(NB that Sf.com uses an ambiguous date as an example on the above page and don’t appear to specify which it’s meant to be. (it’s meant to be displaying Feb 1, 2008, - not Jan 2, 2008). Canada settings are same as UK: dd/mm/yyyy hh:mm)
I was trying to bring in a date-time field from Excel using the Wizard. I didn't want to dump the time setting. My Excel sheet was using a custom time setting that *appeared* to correspond with my locale setting in sf.com. (ie don't select Date, select Custom to see the format) The Excel setting was dd/mm/yyyy hh:mm. I also had seconds in my Excel sheet (they did not create a problem)
The way i solved this problem was by noticing in the supported locale setting for my locale, Canada, that sf.com was only accepting a 12-hour clock setting, not the 24-hour clock setting that was displaying in Excel. Originally, I didn't think this was a problem because when I actually set focus to the Excel field, it displayed a 12-hour clock setting in the field contents bar at the top of the sheet, so I figured Excel was storing a 12-hour clock. So, to resolve, I regenerated the original Excel sheet so that the date both displayed on the sheet and which showed in the field contents bar (once you clicked on the cell) was the 12hr clock, as this is the correct format supported in sf.com by the locale setting for Canada. (FYI that all my locale settings, User and Company, in sf were English(Canada) and that the Regional Settings on my computer are English (US). Import flew in with the CSV after this adjustment.)