Local computer is based in the UK - it needs to know what the local time is in Chicago where the package is going
Colin
>Wouldn't the local computer where the application is installed know the offset to GMT?
>
On Error *
>lcComputer = "."
>loWMIService = Getobject("winmgmts:\\" + lcComputer + "\root\cimv2")
>colItems = loWMIService.ExecQuery("Select * from Win32_TimeZone")
>For Each loItem In colItems
> ?"Bias: " + transf(loItem.Bias)
> ?"Caption: " + transf(loItem.Caption)
> ?"Daylight Bias: " + transf(loItem.DaylightBias)
> ?"Description: " + transf(loItem.Description)
> ?
>Next
>
>Or you can use the GETSYSTEMTIME() (GMT time) and make the diffence against the GETLOCALTIME() API to get the offset to GMT.
>
>>Hi
>>
>>I have a database which contains information about packages to be delivered all over the world - I want to be able to find out the local time at destination without having to calculate it manually
>>
>>So for example if I have a package to be delivered to Chicago I can automatically calulate that the time difference is 6 hours behind the UK
>>
>>Anyone ever done any work in this area?
>>
>>Thanks
>>
>>Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing