DATETIME Issue

[Ricky]

Hello,

I have an infopath form that retrieves a datetime field from my database and
inserts it into a repeating table. Everything works fine except the display
data is 8 hours behind, but if I have it show the xml
data(2005-2-23T03:00:00) without formatting(2-23-2005) it shows up fine(just
messy format). Has anyone ever encoutered this problem or know of a way
around it? Any help would be greatly appreciated.

Thank you,
Ricky

 

[Brian Teutsch [MSFT]]

InfoPath does not currently handle dateTime XML values containing a time
zone offset correctly. There are issues both with displaying the right
value, and further issues if you attempt to edit those values (the time zone
is discarded).

Unfortunately the only workaround is to parse those values yourself and use
code to display and store the correct values.

Sorry,
Brian