Call to webservice at https://na17.salesforce.com/services/Soap/u/28.0/00Do0000000Zb9Z failed. Reported error:
The webservice call failed. The web service returned a SOAP Fault:
Code: soapenv:Client
Message: '02/03/2015 11:20 AM' is not a valid value for the type xsd:dateTime


I use jitterbit to get all of my order/customer data into Salesforce for CRM.

All of my OrderTime on orders read as: 12/30/1899 3:25 PM


I have been trying to fix this using CVTDate

FOrmula such as:
<trans>
CVTDate(Now(),"?m/?d/yyyy HH:MM:SS AP", "mm/dd/yyyy HH:MM AP")
</trans>


My ordertime data from my db reads as 2/3/2015 9:30:35 AM

What CVTDate line can I use that works? Ive tried like 8 ways.



 

Call to webservice at https://na17.salesforce.com/services/Soap/u/28.0/00Do0000000Zb9Z failed. Reported error:
The webservice call failed. The web service returned a SOAP Fault:
Code: soapenv:Client
Message: '02/03/2015 11:20 AM' is not a valid value for the type xsd:dateTime


I use jitterbit to get all of my order/customer data into Salesforce for CRM.

All of my OrderTime on orders read as: 12/30/1899 3:25 PM


I have been trying to fix this using CVTDate

FOrmula such as:
<trans>
CVTDate(Now(),"?m/?d/yyyy HH:MM:SS AP", "mm/dd/yyyy HH:MM AP")
</trans>


My ordertime data from my db reads as 2/3/2015 9:30:35 AM

What CVTDate line can I use that works? Ive tried like 8 ways.