todays date

  • Thread starter Thread starter rml
  • Start date Start date
R

rml

I'm trying to run a query based on todays date. What is
the syntax for today in the criteria line.

Thanks.
 
Date() should work, unless your date field contains both date and time data,
as when filled using the Now() function. If that is the case, you should
use:

BETWEEN Date() AND DateAdd("d", 1, Date())

Or, you could use the DateValue() function to convert your date/time field
to contain just the date portion and use Date() in the criteria link.

HTH
Dale
 
Back
Top