I was migrating the dates from a DBF file to Salesforce.com using the Data Loader and date becomes the date it was 1 day before. This happens for all the fields which contains the date value.
FDR Renew Date – 02/14/2012 – (record in excel file – before migrating the data)
FDR Renew Date – 02/13/0212 – (record in Salesforce – after migrating the data)
Earlier I though I need to check the Time Zone and the locale of my Salesforce.com but it didn’t worked out. Then I spend few hours to figure out the solution for the same. Ideal solution is that dates need to be loaded in the the specific format: YYYY-MM-DDT00:00:00.000Z, e.g. for 02/14/2012 should be 2012-02-14T00:00:00.000Z (See the below mentioned screenshot).