Inserting date fields by data loader
This post answers the following question What should be the date format while uploading by data loader Its always tough to upload the dates/date time through data loader due to the lack of proper documentation. Below table shows the exact format while uploading dates/datetimes through data loader. Also find the URL below for more details. Format Format Syntax Example Date only YYYY-MM-DD 1999-01-01 Date , time, and time zone offset YYYY-MM-DDThh:mm:ss+hh:mm YYYY-MM-DDThh:mm:ss-hh:mm YYYY-MM-DDThh:mm:ssZ 1999-01-01T23:01:01+01:00 1999-01-01T23:01:01-08:00 1999-01-01T23:01:01Z here's a link to the guide: http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic=Content/sforce_api_calls_soql.htm