Question on MS Query in Excel

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
I've used

=Now()

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

Michael Bond
 
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
 
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
 
Back
Top