How refer to current date in Excel SQL query?

  • Thread starter Thread starter Ronald S. Cook
  • Start date Start date
R

Ronald S. Cook

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
 
Ronald, Here is the way I handle the Date issue..

strToday = DateValue(Now())

SQL = Select * from MyTable where DateField < strToday
 
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:
 
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
 
Back
Top