Working with Time Zones
This video was created in response to a question asked at AccessForums.net. It demonstrates an example application used to show the current date & time in different time zones with times being updated each second. The displayed times allow for daylight saving settings where these are currently in place for particular countries/time zones.
The example application can be downloaded from
https://isladogs.co.uk/dl/TimeZones/T...
TIMES:
0:00 Intro
0:12 Idea based on question asked at AccessForums.net: https://www.accessforums.net/showthre...
0:25 Brief outline of form used in app
0:51 Look at the app ..with form showing dates/times in various time zones; times updated each second; daylight savings included
1:09 Currently (11 Nov 2021) only New Zealand in Daylight Savings - summer in Southern hemisphere
1:25 Change default time zone - double click on Time Zone field
1:37 Iran has time zone UTC + 3.5
1:55 Changed date/time in Windows Settings to 4 Oct 2021 - form automatically updated with UK & US also now in Daylight Savings
2:35 Table with saved data for each time zone in use
3:57 Query including calculated fields used as record source for the form
4:40 Use of Wingdings2 font to display tick symbol
4:52 Form timer event with interval = 1000 (milliseconds) to update times each second
5:58 Add additional time zones e.g. using data from https://24timezones.com/time-zones
6:11 VBA code used - 4 functions ... explained .... to check for daylight savings and then get time zone adjustment compared to default time zone
8:29 Recap of 4 functions
8:45 Query explained including calculated fields based on those functions
9:38 Changes needed to handle time zones with part hour UTC values
10:24 Thanks for watching ....please like/comment/subscribe.