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.
>
>>I'm sorry, pretend I'm even more stupid than it appears and explain it to me again. If I'm running this on a PC that is the EST time zone why is there an offset? I thought the point was to end up with the date and time that the app is running in.
>>
>>>You're adding Timezone offset for your PC to the local time on the same PC. The local time has that offset already applied to it.
>>>You can get GMT/UTC time as comment in the code says
>>>

>>>? DATETIME() + lnTimeZoneOffset
>>>

>>>