Question on MS Query in Excel

[Bill]

I have a spreadsheet that has an MS Query embedded in it.
The query pulls from a database and then returns the data
to the excel spreadsheet. I have a field that I'm
prompted for called Received Date. Right now, when I open
the spreadsheet I get a dialog prompting me for the date.
What I want to do is change this to automatically use the
current date.

I right click on the data in the spreadsheet and select
edit query. Here is where I need help. I can't seem to
pinpoint the syntax to use today's date. I've tried
=Today()
=Date

and so on. Can any one tell me how to do this?
Thanks
Bill

 

[Michael Bond]

I've used

=Now()

successfully in the past to set today's date...have you
tried that

Michael Bond

 

[Bill]

I just did tried it and get the error: 'Now' is not a
recoginzed function name. Satement(s) can not be
prepared. Same thing with Today and Date.

Thanks!
Bill

 

[Phobos]

What is the SQL statement you are using?

P

 

[Bill]

Here is the SQL...Thanks!

SELECT CallLog.CallID, Subset.LASTNAME, Subset.FIRSTNAME,
CallLog.CallType, CallLog.ShortDesc, CallLog.RecvdBy,
CallLog.RecvdDate, CallLog.RecvdTime, CallLog.ModBy,
CallLog.ModDate, CallLog.ModTime, CallLog.Tracker
FROM heatdb.dbo.CallLog CallLog, heatdb.dbo.Subset Subset
WHERE Subset.CallID = CallLog.CallID AND
((CallLog.Tracker='HaggardB') AND (CallLog.RecvdDate=?))
ORDER BY CallLog.Tracker, CallLog.RecvdDate,
CallLog.ModDate