Time conversion script?

[Rmcta]

My access database contains records from different locations around the globe. The time on each transactions is the "US Eastern Standard Time" and I need to convert it so that my reports displays the correct local time for each city where the transaction takes place.

Is there a script out there I can use?

 

[thecreator]

My guess is that you would need to maintain a table of locations and time differentials (eg Melbourne, +10) and then use this (joining on location) to calculate the correct local time.

Hope this helps

 

[Rmcta]

Thank you1