getting last 6 months of data from todays date

  • Thread starter Thread starter Addy
  • Start date Start 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
---------------- -------------------- --------------
 
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:
 
Back
Top