Having difficulties displaying dates across different timezones. Used

Cyril over 11 years ago

Having difficulties displaying dates across different timezones.

Used 'usertimezone(pp!initiator)' to capture the initiator's timezone (stored in a text field).
When we display the dates in subsequent screens we use 'local (pv!datetime,timezone) This does not display the correct time.
Now store the dates as text - yes they display correctly, but now have a new problem.
We use the pv!date_time values for validation. If we hide the date_time fields validation fails, if we display date_time, validation works but we have confusion showing allt he dates.

How can we get one solution that will work?...

Discussion posts and replies are publicly visible

Parents

0 Cyril over 11 years ago

Some more information:
I now capture timezone() - ourput fromt he first form in the process

Display date/time (stored as text) = 08/02/2012 08:00 AM (what I entered)

Display date/time (gmt(pv!datetime,timezone_int) = 8/2/2012 1:00 PM

Display date/time (local(pv!datetime,timezone_int) = 8/2/2012 3:00 AM

How can I get the original date to display correctly as a date/time data type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Cyril over 11 years ago

Some more information:
I now capture timezone() - ourput fromt he first form in the process

Display date/time (stored as text) = 08/02/2012 08:00 AM (what I entered)

Display date/time (gmt(pv!datetime,timezone_int) = 8/2/2012 1:00 PM

Display date/time (local(pv!datetime,timezone_int) = 8/2/2012 3:00 AM

How can I get the original date to display correctly as a date/time data type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data