I am trying to append a record from a excel sheet into a sharepoint list. This record consist a TIME column with values in the format " 10:00:00 AM ". When I try to use CAML query and UpdateListItems webservice
I have the following message in InnerText of theXML node returned by UpdatedListItems
" 0x8102001cInvalid date/time value
A date/time field contains invalid data. Please check the value and try again.0x8102001cInvalid date/time value "
Please let me know how to populate the list field with " 10:00:00 AM " format or somekind of acceptable time format.