MS Query, DB2 tables and error CLI0113E

R

RW

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.
 

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

Similar Threads

Access error (ODBC) sometimes 1
>today() does not work 2
Error Editing an MS Query in Excel 1
undefined name in pass-through query 1
Using Append Queries with Linked Tables 3
Elapsed Time returned from query 1
MS Query and date format 3
SQL Server ODBC Error 0

Top