Displaying Country Time

[Nishikawa]

Hi,

If there anyway where we get use system time to calculate country time?

E.g. I have a form and a text box. I enter the country's name or code (JP) into the text box and access will display the current time in that country.

I read about GetTimeZoneInformation in MSDN but do not think this API is able to help me.

Anyone?

 

[DCrake]

I have half completed the task for you. What you will need to do to complete it is to parse out the time element such as +01:00, -08:30. Convert it to minutes (hours*60 + minutes) then do a DataAdd to add or subtract the number of minutes from the current to show the time in that location.

Note the current time settings are taken from the registry.

 

[Nishikawa]

Hi DCrake, Thanks a lot for your help. I will take a look. You are really a saviour... and I dislike my management...kekeke