hi,
yes it can be done. what method are you using? post your code.
in your SQL statement you will need to add a where clauseafter the select...
where datefield = [what date?]

regards
FSt1

"Traci" wrote:

I am trying to add a prompt for a date to make my external data pull from a
certain date only does anybody know how to do this. I am pulling from a SQL
Database and have to have a date prompt or I exceed the row limits set in
excel. I don't think it can be done but wanted to ask anyway. Thanks for
the help.