>=(Now()-1)

  • Thread starter Thread starter Novice2000
  • Start date Start date
What does this mean in criteria for date? Thanks

It means the query should return those records whose date field has a
date value greater than or equal to yesterday at whatever time of day
you are running the query. In other words, if you run the query today
(8/25/2008) at 1:50 PM, it will return all record between 8/24/2008
1:50 PM on into the future. Records with a time value of 1:49 PM and
earlier will not be returned.

Most often, the time value is not a part of a date entry, so it's best
to use Date() instead of Now().
= Date()-1
will return all return all records from yesterday on into the future,
regardless of the time the query is run.
 
Back
Top