How refer to current date in Excel SQL query?

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


<[email protected]> wrote in message
news:[email protected]...
> 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


<[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >