May just be the position/use of your parenthesis.. I tried the
following clause in MS Access and then in the MS Query window and both
gave me the same result..

WHERE ((TblTraffic.RPT_DATE)<Now())

HTH,
Will


Ronald S. Cook wrote:
But what I'm writing is write in the SQL query window so I can't establish
variables, etc.

I tried the below but it didn't work either:

SELECT e.EVENTNAME, e.EVENTDATE
FROM EVENT e
WHERE (e.EVENTDATE = DateValue(Now())
ORDER BY e.EVENTDATE


wrote in message
ups.com...
Ronald, Here is the way I handle the Date issue..

strToday = DateValue(Now())

SQL = Select * from MyTable where DateField < strToday



Ronald S. Cook wrote:
I'm trying to use Microsoft Query within Excel to write a SQL query
against
a data set.

SELECT e.EVENTNAME, e.EVENTDATE
FROM EVENT e
WHERE (e.EVENTDATE = DATE()
ORDER BY e.EVENTDATE

In the above, DATE() is not correct to get the current system date. I
tried
DATE, NOW, NOW(), GETDATE, GETDATE(), TODAY, TODAY().. now of which
worked.

Can someoine please tell me the correct syntax?

Thanks!
Ron