>Basically -- it's better to get the UT directly rather than convert form local time. Part of the snag is functions like DATETIME() and TIME() *don't* tell you if the time they return are in terms of standard local time or daylight local time -- and specifically a problem on the day on which the transition from daylight to standard occurs -- local time repeats (and in the case of the USA where daylight saving occurs, there is a 1-hour "window" where local time repeats -- once for daylight, and once again for standard).

DateTime() and Time() are always returned in the active locale that Windows is running under so you can find out what that is by calculating the timezone offset with GetTimeZone() from Win32.

+++ Rick ---