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?

Members

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.

•  Extended Cut Video - Silver
•  Database Template Download - Gold

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!

Links

• Time Clock Video: https://599cd.com/TimeClock
• DST Code: https://599cd.com/DSTCode
• Calculating Hours Worked: https://599cd.com/TimeSpent
• Daylight Saving Time in Excel: https://599cd.com/ExcelDST

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

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