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



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

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

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