GMT

O

Oncle Sam

I'm working with dates from InfoPath 2003 SP1 release on July 27. I get dates from DataSet from Web Service placed on IIS. My IIS placed in GMT zone that means that DataSet returns values from it like this: 2004-05-22T19:00:00.0000000-00:00 I use this Web Service in InfoPath form. When I get this datetime value to
InfoPath it displays like this 2004-05-22T19:00:00.0000000+06:00. And then I
set Format condition on that date I get 23.05.2004 01:00:00 It means that
InfoPath just added 6 hours to the original date. I try to resolve that
problem.

I put all my hope on the release of SP1, but this bug still not fix !!!

Any idea



1.. I changed the time zone on IIS. The result - IIS returns datetime with
time zone offset, but for InfoPath it has no effect, still adds 6 hours
2.. I changed the time zone on client where InfoPath installed - the time
changed on client, but for InfoPath it has no effect, still adds 6 hours
3.. I saved the InfoPath form and then manually edited the date from
2004-05-22T19:00:00.0000000+06:00 to 2004-05-22T19:00:00.0000000-00:00. When
I opened it in InfoPath It works great - the date displayed in its original
state.


Sounds like something wrong in InfoPath time offset settings. Please tell me
is it a bug in InfoPath 2003 SP1? Or tell me how to get the original date
and time values in InfoPath 2003 SP1?
 
B

Brian Teutsch [MSFT]

A few questions that will help us start out. Where have you done
breakpoint-style checks on the value?

Web Service:
Before the data is sent - verify that it is -00:00

InfoPath DOM:
before it's displayed in the view - verify that it is +06:00

This will help us know if the Web Service is doing some formatting that
you're not aware of, or if InfoPath is doing internal formatting of the web
service XML before putting it in the view.

Not positive, but information about the data formatting should be secondary.
We will format based on the time zone in the XML, but not based on the
machine time zone at all.

Brian
 
Top