Time Zone script

[pnelson]

Does anyone have a script that will look at address and/or phone number fields of a given record to lookup the correct time zone that record is in and then insert the current date and time? That would be very handy if you could share it. I saw a post (Post#262763 - http://www.fmforums.com/forum/showpost.php?post/262763/) on another thread showing how to calculate UTC time that was sort of on the right track minus a way to look up and/or calculate the UTC offets needed to figure out the right value for your given record. I also found a nice little Mac OS X app ( http://www.veladg.com/velaterra.html ) that does a lot of what I'm looking to do. Apparently the tz database is the foundation for this. Has anyone done a FileMaker version of the tz database? Thanks in advance to anyone that has a solution to offer for simplifying time zone lookups and UTC offset calculations.

Edited June 19, 2008 by Guest

[comment]

All you need to know is the current UTC/GMT, which you can get from many websites. Then compare it to the current local time and you've got your offset - without needing an address or phone number, and even if the computer's time is set incorrectly.

[pnelson]

I was hoping someone had already automated a procedure in FileMaker that would do that. I don't want to do manual lookups and I'd like a flexible way to handle the presentation of time zone information for any given record. Has anyone used the tz database via FileMaker to accomplish something along these lines?

http://www.twinsun.com/tz/tz-link.htm

If I do need to go to a web site to post and retrieve info, it's looking like the Troi URL plugin would work:

http://www.troi.com/software/urldownload.html#dldNative

Edited June 19, 2008 by Guest

[comment]

Sorry, I misread your post. I thought you wanted to get the timezone of the user. Getting the timezone per record is going to be much more difficult. AFAIK, state/area code boundaries do not always match time zome boundaries. Even the Olson Timezone Database works by making you select the nearest major city in your time zone.

[RodM]

>>>>All you need to know is the current UTC/GMT, which you can get from many websites. Then compare it to the current local time and you've got your offset>>>

Not certain how I go this... the compare??

my clients are in another time zone.. i need to timestamp there messages with their own zone not my timezone

Edited July 18, 2010 by Guest

[comment]

Please keep your issue to one thread only:

http://www.fmforums.com/forum/showtopic.php?tid/215708/

http://www.fmforums.com/forum/showtopic.php?tid/206495/