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
 

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 Criteria Range 1
Excel Date Count 2
Excel Message box with days of month & date. 1
Update query with date criteria 3
Pivot table macro filter data between yesterday and today (date+time) 0
=Date() Problem 2
IIF function for 3 criteria, possible? 2
Same Criteria For Multiple Fields 5

Back
Top