[SalesForce] Apex Data Loader is loading previous date

Apex Data loader is loading previous date.

  • Salesforce Organization Default Time Zone is GMT+05:30
  • Salesforce User Time Zone is GMT+05:30
  • Apex Data Loader time zone is GMT+05:30
  • CSV, for Apex Data Loader, has date as 2013-01-01
  • Salesforce is showing 12/31/2012

Is this an Apex Data Loader bug, or am I missing something? Is is time to move to a different Data Loader?

Best Answer

Not a bug. This is documented, make sure your source file has the dates with this format. (Specify the time)

YYYY-MM-DDThh:mm:ssZ

http://help.salesforce.com/HTViewSolution?id=000005099&language=en_US