Expert: Scottgem - 2/22/2005

Question
Hello,

  I have a table with few datetime fields. Those fields are filled in different situations and sometimes in different localizations.

Is there a way to get values of those fields in a common GMT/UTC timezone?

For now I am loosing few hours calculating difference between those fields.

To be more precize those fields are always filled with the now() function, maybe then I have to get the now() value as a universal time somehow ?

Regards,
Tomasz.

Answer
The Now function picks up the system time that you PC is set for. No way to change that.

You should be able to use the DateDiff function to add or subtract the difference between your local time and whatever time zone you want. The only other thing I can think of would be to see if you could pull time for a specific zone using something like worldtime.com.

HTH
Scott<>