SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using the Ruby gem 'viewpoint/spws' (from a RHEL 6 server) to insert items into a Sharepoint list via SOAP.

It seems that the DateTime fields being passed are being incorrectly interpreted by the server. Examining the SOAP messages being passed, I see that the response is indicating that the timezone offset (-05:00 for EST in my case) is being negated then added to the minutes portion of the time.


SOAP Request: 2012-12-26T14:00:00-05:00
SOAP Response: "2012-12-26 14:05:00"


SOAP Request: 2012-12-26T13:30:00-05:00 SOAP Response: "2012-12-26 13:35:00"

Examining the list in Sharepoint also shows this "+5 minute" entry.

Also, if I submit the request without the offset, this is entered as expected.


SOAP Request: 2012-12-26T13:30:00Z
SOAP Response: "2012-12-26 13:30:00"

I've been looking for an explanation of this behavior but I'm not having any luck finding one. Any suggestions would be appreciated.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.