Date Problem – While working with Data Loader

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.

Example –
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).

The Date Example

Advertisements

About smattey

Sumit Mattey is the Leader, Cloud Technologist & Evangelist, Husband, Father and Fun Loving person. Currently working as - PROJECT MANAGER, R Systems Int'l Ltd.(Salesforce) Not simply defined by his career, Sumit lives with his family (whom he loves so much). He is an avid movie buff, a big book worm, a lover of food and beverage. While his schedule has not been forgiving as he'd like, he also enjoys doing photography with great outdoors and tries to hunt as often as possible.
This entry was posted in Cloud Computing, Salesforce.com and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s