Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 6 down vote accepted

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

share|improve this answer
    
Thank for your time and answer. What is the T and Z in your DateTime format? Can you give me a sample DateTime in the format which you have mentioned? Thank you in advance. –  Suman Krishna Saha Mar 23 '13 at 17:37
1  
It specifies the time of the day and time zone. See this w3.org/TR/xmlschema-2/#isoformats. By the way, you will help other users by marking the original answer as such :) –  PepeFloyd Mar 23 '13 at 18:04
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.