How to Format Dates in Queries for Access 2010


show more Formatting dates provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth show less
please wait ...

Formatting dates

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 as we saw in the previous movie we have an infinite number of ways that we can display our data. One of the ways that we can do that is with the Format function. The Format syntax looks like this.

It requires two pieces. It requires the expression that we want to format and this is where we want to plug in our DateField, and it requires some symbols. For the symbols we have a variety of options. We'll use a lowercase d to represent days, m represents months, y represents years. We can also use q for quarters, wd for weekdays, and ww for weeks of the year. We'll use these symbols in a var...

Formatting dates
Video duration: 4m 31s 3h 2m Intermediate

Viewers:

Formatting dates provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth

Subject:
Business
Software:
Access
Author:
please wait ...