Calculating Time Zone Differences
Posted on 2008-06-22
I haven't worked with FM for some time and I can't find this answer in the books/manuals I have....
I have a lookup field "Time Zone" that finds and displays the time zone name ("Eastern", "Central", etc.) based on area code. It works fine.
What I now need is a way to use "Time Zone" to calculate what the current time is in, say, "Pacific" if I'm in "Eastern" and show Pacific local time in a field called "Time Zone Calc". IOW, if the current time is 5:29pm EST then "Time Zone Calc" should say "2:29pm".