getting last 6 months of data from todays date

A

Addy

Hello all people.

I am running into some problems with a query. Basically what I want to
pull out from a table are all contract dates that ended 6 months from
todays date. So in a nutshell I am filtering out 6 months of past data
from today.

How would I code my criteria in the query.

Here are the field names I am working with.

Description Contract End Location
---------------- -------------------- --------------
 
M

Marshall Barton

Addy said:
I am running into some problems with a query. Basically what I want to
pull out from a table are all contract dates that ended 6 months from
todays date. So in a nutshell I am filtering out 6 months of past data
from today.

How would I code my criteria in the query.

Here are the field names I am working with.

Description Contract End Location
---------------- -------------------- --------------
Click to expand...


Just set the criteria for the contract end field to:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last 6 months but not last years data 3
Displaying data from the past six months 1
Todays date minus 6 days before (Shows all records in 6 days) 2
Date Criteria Range 1
Creating a "grid" of data 3
Date search query 0
Listing dates greater than 6 months from today 3
Query - pull past 12 months 1

Top