Using the DateDiff function

In the last movie we took a look at how we can use the DateAdd function to allow…us to specify a date in the past.…I'm going to go ahead and open up the query that we are working on, and that is…called to qry_RecentOrders.…And if I go ahead and view it in Design View, I'll open up our field and we can…take a look at the Criteria.…So I specify that we want to view order dates that are greater than and then…we're using or DateAdd function to specify the date 30 days ago.…Now if I run this query again, I'll take a look at it, and I know that all of…these orders were placed within the last 30 days, but I don't know exactly how…many days ago that they were placed.…I can use the DateDiff function to tell us that.…

Let's go back into Design View and we're going to create a new calculated field…here and let's do that in the Zoom box.…The name of this field is going to be Days Elapsed.…And the function that we're going to using is DateDiff and this function…is similar to DateAdd.…It requires three arguments.…