Defining today's date


show more Defining today's date 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 ...

Defining today's date

So far, we've taken a look at how to work with dates relative to each other or relative to a specific and static date range. Access provides a couple of additional functions that will allow us to define dates relative to today or relative to right now. These are the queries that require a date range such as within the last 30 days or 2 weeks from today. The first part requires us to accurately define today's date. In the next movie, we'll take a look at how we can combine this with some additional functions to perform some calculations to define time span. Let's start a new query in Design view.

Create, Query Design, and I'll add our Orders table. Go ahead and say Close. Instead of building an actual query, I'll use the fields here to demonstrate the Date, Time, and Now functions. The Date function is written like this, Date(). This tells Access to fetch the current date. In the next field I'll write out Time followed by an open and closing parentheses. This tells A...

Defining today's date
Video duration: 2m 41s 3h 2m Intermediate

Viewers:

Defining today's date 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 ...