ServerGMT = ServerLocalTime + ServerTimeDiff
LocalTime = ServerGMT - LocalTimeDiff
>Ok, I'm still feeling a bit dumb here. Are you saying the I will know the difference between GMT and whatever my local time is, and I also will know the difference between GMT and whatever time the app is going to run in, so I can do something like this?
>
>LocalTimeDiff - ServerTimeDiff = AppTimeAdjustment
>
>
>>You have your local time already returned by DATETIME() function. Doug's code gives you info about your Timezone. It can be used to convert the local time to GMT or if you have some other time in GMT you can convert it to the local time.
>>
>>Check also George Tasker's
Windows Time file #
9738 that shows how to do that through Windows API.
--sb--