Friday, July 13, 2012

SQL Server date format for Salesforce upload

convert(nvarchar,datefield,126)

produces yyyy-mm-ddThh:mm:ss.mmmZ

e.g. 2008-10-02T10:52:47.513Z

(Must also set date format and time zone in Data Loader)

No comments: