TimeZone Conversion

[webidev]

Hi All,

My problem is converting the Timezone. My server is in Eastern Time Zone, but users can be anywhere in world. So I wanted them to see the time of their records in their local time.

I'm trying to write a formula as

shiftdatetime(currentdatetime, "EST,300,EDT", "GMT,0,GMT") but i don't think its working or not.

If anyone knows how to write it that would be appreciated

 

[Madawc]

The normal method for shifting times would be

DateAdd ("h", 5, {your.datetime})

Intead of 5, you could have a variable which you would set in another formula field, depending on their time zone. The 'Case' command is useful when selecting between a lot of alternatives, neater than a string of If statements.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10