function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SKollcakuSKollcaku 

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
Best Answer chosen by SKollcaku
Shalom RubdiShalom Rubdi
Skender - are you trying to insert dates or date/time values?  If the data type of the field is of type Date, then the format should be: YYYY-MM-DD

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

Shalom RubdiShalom Rubdi
Skender - are you trying to insert dates or date/time values?  If the data type of the field is of type Date, then the format should be: YYYY-MM-DD

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
This was selected as the best answer
Shalom RubdiShalom Rubdi
Here is a more specific link for Data Loader:

https://help.salesforce.com/apex/HTViewSolution?id=000004680&language=en_US 
SKollcakuSKollcaku
The format is Date. The trick was to open the csv file with CSVEd eand then add as a suffix 10:00:00.
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