Daylight Saving Time
By Richard Rost 3 years ago
Daylight Saving Time - Storing UTC (GMT)
In this Microsoft Access tutorial, I will teach you how to deal with Daylight Saving Time calculations by storing UTC (Universal Time Coordinated, or Greenwich Mean Time) in your database.
Paul from New York, NY (a Gold Member) asks: I run a 24-hour restaurant. Tonight, Daylight Saving Time ends and the clocks go back from 2am to 1am. This is going to mess up the time clocks for my employees who start at midnight and work until 8am. How do I adjust my Access database for this aside from manually editing their time cards twice a year?
I'll show you how to use an Internet Time Server to get the current UTC time regardless of what your system clock is set to or where you are located. This also prevents against employees manipulating their system clocks.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
TechHelp Access #msaccess api utc, gmt, daylight saving time, daylight savings time, dst, get internet time, get time from internet, system clock, 24 hour time, time clock, time card, timeclock
Subscribe to Daylight Saving Time
Get notifications when this page is updated