Using Query to return data from SQL database

[DOOGIE]

I am using an Excel spreadsheet to query a SQL database for information that
is stored by various dates. I only want to return information that was stored
in the SQL database within the last 24 hours. However, I run into a snag when
I am using the query wizard within Excel. When I get to the point where the
wizard asks if I want to filter the data I am retrieving, I enter that I want
the date field filtered by greater than or equal to "Today()-1". However,
Query does not recognize the Today() function. What should I enter to filter
my data by the date less than or equal to the last 24 hours or 1 day?

 

[A&A - In Any Place]

See this solution in: http://inanyplace.blogspot.com/


ANDRÉ BERNARDES
A&A - In Any Place

Acesse o portfólio:
http://www.slideshare.net/bernardes/informaes-ao-invs-de-dados-presentation

MSN: (e-mail address removed)
SKYPE: inanyplace
TWITTER: bernardess

My Profile: http://al-bernardes.sites.uol.com.br/
My Blog: http://inanyplace.blogspot.com/
In LinkedIn: http://www.linkedin.com/in/andrebernardes
In Plaxo: http://andrebernardes.myplaxo.com/
In Jobster: http://www.jobster.com/people/andrebernardes
In Unyk: http://www.unyk.com/pt/id/9571234

My experiences:
http://andrelbernardes.sites.uol.com.br/MIS.html
http://andrelbernardes.sites.uol.com.br/XLS.html

Acesse meus Feeds:
http://www.google.com/reader/shared/17429357110218427555

 

[DOOGIE]

I apologize, but I cannot seem to find the answer in your link below. Could
you please forward the function to me?

 

[Cydonio]

HI,
try the Date funtion instead, like this:
Date - 1