Using Query to return data from SQL database


D

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?
 
Ad

Advertisements

D

DOOGIE

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top