Daylight Saving Time and your Microsoft Access Database - Storing UTC (GMT) for Employee Time Clocks

Learn how to deal with Daylight Saving Time calculations by storing UTC (Universal Time Coordinated, or Greenwich Mean Time) in your Microsoft Access databases.

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?

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will 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.

MEMBERS ONLY VIDEO:
   • Daylight Saving Time and Microsoft Access ...  

BECOME A MEMBER:
   / @599cd  

LINKS TO TOPICS MENTIONED:
Get on my Mailing List: https://599cd.com/YTML
Time Clock Video: https://599cd.com/TimeClock
DST Code: https://599cd.com/DSTCode
Calculating Hours Worked: https://599cd.com/TimeSpent

ADDITIONAL RESOURCES:
FREE Access Level 1: https://599cd.com/Free1
FREE Customer Template Database: https://599cd.com/XCDT
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Survey: https://599cd.com/survey
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, 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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.