title: Web Service Dates with timezone info
body: <p>I am quering a (.net) web service from Excel (<em>takes cover from the backlash</em>), which returns a array of dates. I have noticed that any date that is on the day boundry gets shifted forward 1 hour, I have checked the web service on the server and the original date is correct.</p>
  
  <p>I then used Fiddler to view the call on the client machine, and the dates which are at midnight have a Z on the end (to mark it as UTC) where as all other date times don't.</p>
  
  <p><strong>UPDATE The above statement is wrong, it is the first and last date that is marked with a Z, it doesn't matter what the time is. The rest is correct that the client only adjusts the first and last date</strong></p>
  
  <p>I take it SOAP is then changing this from UTC to local (BST) and therefore adding an hour.</p>
  
  <p>My question is how can I stop the Z from being added onto these dates (or change it to local)?</p>
  
  <p>I have checked the culture in IIS 7.5 and it is set to en-GB, the server is set to UK.</p>