Date Criteria Range

  • Thread starter Thread starter Wes
  • Start date Start date
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.
 
Assuming that you're using the criterion on a date datatype field:

Between Date() - 180 And Date()
 
Back
Top