Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query, DB2 tables and error CLI0113E
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding tables in a query | Excel Discussion (Misc queries) | |||
MS Query Outer join with three tables | Excel Discussion (Misc queries) | |||
MS Query No visible tables | Excel Discussion (Misc queries) | |||
Web Query from multiple tables | Excel Discussion (Misc queries) | |||
Two Excel tables in MS Query | Excel Discussion (Misc queries) |