Excel SQL (Query) - how to filter by date

[futbol1097]

I am using Microsoft Query in Excel to pull in data via SQL from a database into my spreadsheet. However, I want Query to only pull in data that falls within a given date range, between NOW() and 14 days ago. If the data does not meet that criteria, it is not displayed.

How do I write the SQL statement to determine time?

Thanks,
R

 

[sdurocher]

While in the query, select View and then Criteria. A new section will apear. Pick the header that has the time. Then input your time range formula in value.

This website will have more details http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/build_query_4.html