From the course: Access 2019: Queries

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Dates as serial numbers

Dates as serial numbers

From the course: Access 2019: Queries

Start my 1-month free trial Buy for my team

Dates as serial numbers

“

- [Instructor] You would think that storing dates in your database would be a fairly straightforward and routine operation. Luckily on the surface, to you and I, it is. But behind the scenes, Access does a lot of work to make sure that your date-specific records are kept in order. Understanding how Access stores, retrieves and formats date and time-based data can really help you out down the road. And there's lots of different functions that are built in that deal specifically with dates and times. Let's start with a small database that I've got created here that has two tables for dates and times. I'm going to double-click on the Dates table, and we'll see what's inside. Here we have a column called Dates, and it just has dates that range from the 1700s into the 1800s, and if I scroll down, we'll see dates in the 1900 range, all the way up to today's current date for me, which is September 19th, 2018. I'll close this table down and open up the Times table. This one has times starting…

Contents