Ok , this may sound weird but here goes.
I’m doing a Database query ( in EXCEL through MS Query ), the query requires dates such as,
Created Date: >=#8/1/2002 12:00:01 AM# And <=#8/31/2002 11:59:59 PM#
The above string gives me everything recorded ( in the database ) between the dates 8/1/02 and 8/31/02
My question:
Is there away to created a field in the Excel spreadsheet that I can input the date I want to search without going into the MS Query and changing the date?
This is really bugging me. Every time I run the query I have to go in and change the dates, it would be nice if I could just input the date into a box or a field and have the ms query do search on that date.
PLEASE HELP!!!!
I’m doing a Database query ( in EXCEL through MS Query ), the query requires dates such as,
Created Date: >=#8/1/2002 12:00:01 AM# And <=#8/31/2002 11:59:59 PM#
The above string gives me everything recorded ( in the database ) between the dates 8/1/02 and 8/31/02
My question:
Is there away to created a field in the Excel spreadsheet that I can input the date I want to search without going into the MS Query and changing the date?
This is really bugging me. Every time I run the query I have to go in and change the dates, it would be nice if I could just input the date into a box or a field and have the ms query do search on that date.
PLEASE HELP!!!!