I have added prompts to my MS Query but I get an error message after typing
the date at the prompt:

CLI0113E: SQLSTATE 22007 An invalid Datetime format was detected; that is,
an invalid string representation or value was specified. SQLSTATE=22007

If I hard code a date as #2/1/2008#, the query works fine. However, I really
need the prompts to work so I can tie the query to a date in a cell on a
worksheet.

I searched the net for CLI0113E and found the problem but not any solutions.

Any Ideas?

Thanks again.