World times issue

[AccessWillKill]

Is it possible to do this:

http://msdn.microsoft.com/en-us/library/system.timezoneinfo.findsystemtimezonebyid.aspx

in VBA?

i'm pushed for time and struggling to get this done. i've seen many scripts to get information on your current time and everything but i need to get the date and time from 2 other time zones as well as your current time.

 

[jdraw]

Try this link for info.

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=36854&d=1302892416

You may also search for "David Crake time zones". David has made some posts on this.

 

[AccessWillKill]

thanks i will

i'll look into this. i have to take into account all the daylight saving and everything as well you see. it looks good on face value but i'll have to explore the code i will let you know in due course

 

[AccessWillKill]

I have tried and tested it and it does half of what it is intended to. it displays the list of times but does not show anything in the text box when you select it.

i checked the forum page i found on it and someone had the same problem but it was never answered on the forum.

 

[AccessWillKill]

alas i've got it working. Thanks boys.

 

[AccessWillKill]

scrap that... it works. the functionality is all there however the time zones are wrong in certain Areas.

for example it works perfectly in melbourne however in Amsterdam,London, Berlin, and China it is an hour behind. any idea why this may be?


i'm using a different database as well i am using the datetime one

Addition: It also has the same problem in the other database. For some reason it detects the time differences correct but not the actual time. its like for them countries it cannot work out the Daylight saving time for these places.

my clock is set to London which is running on GMT time according to the Database which is an hour behind where it should be. Same for Amsterdam,Belgrade, Paris, China but strangely not Melbourne and arizona

 

[ChrisO]

Please give some time information example such as…

Your computer is set to London, automatically adjusts for daylight saving time set to yes, and it displays: -

London = 11:00:00 PM
GMT = 22:00
Melbourne = 08:00 AM

Then verify at: -

http://www.timeanddate.com/worldclock/

London is on daylight saving time but Melbourne is not.

Chris.

 

[AccessWillKill]

Hello, Thanks for the reply,

Yes i have got some test data so this is what it is coming up as

My PC Time (set to London UTC Time): 12:35 - Correct
GMT Time: 11:35 - Correct

selected times from listbox
London: 11:35 - Wrong (as proven by my local machine time)
Amsterdam: 12:35 - Wrong
Paris: 12:23 - Wrong
Melbourne 21:35 - Correct

Its basically currently not accounting for Daylight Savings by the look of it which is why Melbourne is appearing as correct (not in daylight saving time) and the rest is not.

i'm still probing but havent got an answer as to why i don't know weather the code has a problem or weather it even accounts for DST at all

 

[ChrisO]

Yes, that is why the 'Time Zone' description is Blah Blah 'Standard Time'.

It might be possible the show the daylight saving time in the selected location but I haven't done that.

Chris.

 

[AccessWillKill]

yeah. its near impossible to find one that can do this. its because the whole daylight savings idea is near impossible to sort. different countries change to daylight savings at different times and everything. its a massive pain.

There will be a way but i doubt anyone has the time on their hands to go through each daylight saving time and code rules for each one.
Its a very good script though. Cheers