S
sakieboy
SQL -> Web Service -> InfoPath
My SQL data type is smalldatetime.
My Web Service dataset type is datetime.
My data looks like this:
"11/9/2004"
My SQL statement looks like this:
DATEADD(hh,13,tEOR.AnticipatedStartDateAndTime) AS
AnticipatedStartDateAndTime,
My XML Web Service data looks like this:
<AnticipatedStartDateAndTime>2004-11-09T13:00:00.0000000-05:00</AnticipatedStartDateAndTime>
My data ends up displaying in InfoPath as 8:00 (13 minus 5).
My actual data should reflect only the "13:00:00", I'm not sure where the
"05:00" is coming from. Possibly Grenwich time or something.
Does this have something to do with my regional time settings or something?
If so, where do I need to go and change this at.
Thanks
My SQL data type is smalldatetime.
My Web Service dataset type is datetime.
My data looks like this:
"11/9/2004"
My SQL statement looks like this:
DATEADD(hh,13,tEOR.AnticipatedStartDateAndTime) AS
AnticipatedStartDateAndTime,
My XML Web Service data looks like this:
<AnticipatedStartDateAndTime>2004-11-09T13:00:00.0000000-05:00</AnticipatedStartDateAndTime>
My data ends up displaying in InfoPath as 8:00 (13 minus 5).
My actual data should reflect only the "13:00:00", I'm not sure where the
"05:00" is coming from. Possibly Grenwich time or something.
Does this have something to do with my regional time settings or something?
If so, where do I need to go and change this at.
Thanks