todays 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.
 
D

Dale Fye

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
 
Top