Tweaking date/time stamps

posted Jan 21, 2011, 8:09 PM by Ezra Kenigsberg   [ updated Mar 26, 2011, 3:09 PM ]

#DataTipOfTheDay 2011-01-21

Q: "How can I tweak the date/time stamps I migrate into Salesforce?"

A: The two easiest ways I know:
  1. Change my login's timezone -- or change the timezone in Data Loader's Settings dialog (thanks to Sohail Sikora for this tip!)
  2. Append a adjustment on the end of the date/time stamp; the adjustment should use the format +HH:MM so that the entire date/time stamp has this format: YYYY-MM-DDThh:mm:ss+HH:MM