You need to sign in to do that
Don't have an account?
SKollcaku
Why do I get invalid birthdate data error when inserting csv with Data Loader?
Hi,
I have been trying ll possible alternatives to insert new Accounts with a field of type Date in csv file, but with no success.
I continue to get the fllowing error: Birthdate: invalid date: Fri Nov 07 00:00:00 GMT 27" (this is an example).
I tried to save the csv column as a text but nothing. I also added a suffix with csved tool (10:00:00 as a time). Any sugegstions how to import date fields with data loader (I have checked the flag: Use European date/time format )?
I am using Salesforce with gmt+2 date/time format.
Thanks a lot,
Skender
I have been trying ll possible alternatives to insert new Accounts with a field of type Date in csv file, but with no success.
I continue to get the fllowing error: Birthdate: invalid date: Fri Nov 07 00:00:00 GMT 27" (this is an example).
I tried to save the csv column as a text but nothing. I also added a suffix with csved tool (10:00:00 as a time). Any sugegstions how to import date fields with data loader (I have checked the flag: Use European date/time format )?
I am using Salesforce with gmt+2 date/time format.
Thanks a lot,
Skender
Otherwise, the following documentation from Salesforce offers guidance on Date/Time formats:
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm
All Answers
Otherwise, the following documentation from Salesforce offers guidance on Date/Time formats:
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm
https://help.salesforce.com/apex/HTViewSolution?id=000004680&language=en_US
I should try the format you suggested (convert in Excel first). Would it work even if i use the Italian format (European)?
Thanks again,
Skender