Date and time formats supported by web service
On a form, when you create an entry or modify an existing entry using a web service, you must specify the date and time in the following formats. This facilitates more accurate web service operation.
Date and time format | Example |
---|---|
"yyyy-MM-dd'T'HH:mm:ssZ" | 2016-01-19T09:55:50-0800 |
"yyyy-MM-dd'T'HH:mm:ss" | 2016-01-19T09:55:50 |
The following error message is displayed when you try to use any other date and time format in the web service:
ERROR (8957): The date format is invalid; Unparseable date:
Refer to the following code example of Create operation:
<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:urn="urn:ABTestWS1">
<soapenv:Header>
<urn:AuthenticationInfo>
<urn:userName>Demo</urn:userName>
<urn:password></urn:password>
<!--Optional:-->
<urn:authentication></urn:authentication>
<!--Optional:-->
<urn:locale></urn:locale>
<!--Optional:-->
<urn:timeZone></urn:timeZone>
</urn:AuthenticationInfo>
</soapenv:Header>
<soapenv:Body>
<urn:Create>
<urn:Submitter__c>Demo</urn:Submitter__c>
<!--Optional:-->
<urn:Assigned_To__c></urn:Assigned_To__c>
<urn:Status__c>New</urn:Status__c>
<urn:Short_Description__c>Test25</urn:Short_Description__c>
<!--Optional:-->
<urn:Date_Time_Field__c>2016-01-19T09:55:50.111111000-0800</urn:Date_Time_Field__c>
<!--Optional:-->
<urn:Date_Field__c></urn:Date_Field__c>
<!--Optional:-->
<urn:Time_Field__c></urn:Time_Field__c>
</urn:Create>
</soapenv:Body>
</soapenv:Envelope>
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:urn="urn:ABTestWS1">
<soapenv:Header>
<urn:AuthenticationInfo>
<urn:userName>Demo</urn:userName>
<urn:password></urn:password>
<!--Optional:-->
<urn:authentication></urn:authentication>
<!--Optional:-->
<urn:locale></urn:locale>
<!--Optional:-->
<urn:timeZone></urn:timeZone>
</urn:AuthenticationInfo>
</soapenv:Header>
<soapenv:Body>
<urn:Create>
<urn:Submitter__c>Demo</urn:Submitter__c>
<!--Optional:-->
<urn:Assigned_To__c></urn:Assigned_To__c>
<urn:Status__c>New</urn:Status__c>
<urn:Short_Description__c>Test25</urn:Short_Description__c>
<!--Optional:-->
<urn:Date_Time_Field__c>2016-01-19T09:55:50.111111000-0800</urn:Date_Time_Field__c>
<!--Optional:-->
<urn:Date_Field__c></urn:Date_Field__c>
<!--Optional:-->
<urn:Time_Field__c></urn:Time_Field__c>
</urn:Create>
</soapenv:Body>
</soapenv:Envelope>
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*