From the course: Access 2019: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Format dates

Format dates

From the course: Access 2019: Queries

Start my 1-month free trial

Format dates

“

- [Instructor] There are thousands of ways that dates can be valuable in your database, and just as many variations on how they're formatted or displayed. They can be written longhand for use on business letters, or abbreviated for use on payroll checks. They can be incorporated into serial production or batch ID numbers, or used for quarterly financial reporting. Because Access stores dates as serial numbers, we have an infinite number of ways that we can display that data. One of the ways that we can do this is with the Format function. Let's take a look by creating a new query in Design view, and I'm going to add in the Orders table and the Products table. Then, from the Orders table, I'll double-click on order ID and the order date. And from the Products table, I'll double-click on item. Then, in the fourth column, I'm going to right-click and go into the Expression Builder. The Format function can be found in the Functions folder inside of Built-In Functions, but it's not a date…

Contents