>>
>> ssprocessds.hhpickup.Rows.Clear();
>> ssprocessds.ReadXml(f.FullName);
>>
>>
>>At the client site, when I read 2013-10-24T00:00:00-04:00 from the .xml file ( I don't know how to show the xmlhere)
>>the result in the datetime column of the datatable was 2013-10-23:09:00.
>>
>>It worked fine on my site.
>>I was testing at about 1PM ET.
>>I noticed that time on the client machine was 3 hrs behind me because the Time Zone was Pacific.
>>I changed the time zone on the client machine and got the correct date when reading the xml.
>>Does anyone know why a time zone should push a date back a day in the middle of the day?
>>Also, why would readxml mess with a date at all?
>
>If the time in the column was 9PM, then it would be correct, as the time was adjusted to local time. If it was 9AM, then something else is wrong.
>
>Assuming it was 9PM and adjusted to local time, you have a couple of options:
>1) If you can control the XML that is written either a) write and read the UTC date instead of the local date, or b) leave off the time offset off of the time.
>2) If you can't control the XML, use TimeZoneInfo.ConvertTime (
http://msdn.microsoft.com/en-us/library/system.timezoneinfo.converttime.aspx) to change the time to the timezone it originated from.
Thanks, Rob.
I'll take a look
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.