Date Criteria Range

W

Wes

I'm trying to Make a criteria in a query. Pull today's date and the past 6
months of data.
What i have so far is..

<=Date()-180

But this is not working.. It's pulling all the data from the data base.
 
K

Ken Snell [MVP]

Assuming that you're using the criterion on a date datatype field:

Between Date() - 180 And Date()
 

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

Date search query 0
Criteria help 4
criteria on form 1
Date/Time Selection problem!!!!! 10
Date Field problem 10
Date parameter question 2
Date Brackets as an IIf statement 3
getting last 6 months of data from todays date 2

Top