Skip to content
+1-888-319-3663

COMMUNITY FORUM

Salesforce integration

Jo Ann Wellman asked 7 years ago
If you are working on a Salesforce integration and sending data back to the database, make sure your date field is in the format of YYYY-MM-DD. If it is not in this format, the integration will stall and not load the data.
Lorren replied 7 years ago

Jo Ann,

Thanks for posting this.

You can also use YYYY-MM-DDTHH:mm:sss since Salesforce does accept date/time in the same field.

I use this link to determine how to set the date/time values. The field expression would only be used inside Salesforce.com though.

http://www.salesforce.com/us/developer/docs/officetoolkit/Content/sforce_api_calls_soql_select_dateformats.htm


If you would like to submit an answer or comment, please sign in to the eOne portal.