Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Passing Dates criteria in MS Query
You are correct with the square brackets but you need to add the prompt text
between the brackets [Start Date] and [End Date] -- HTH... Jim Thomlinson "RW" wrote: I am trying to use MS Query to briong back data from DB2 tables. I have the query set up in the design view. I have several sets of criteria. Field1 = '1' Field2 = 'Y' Test Date Between #2/1/08# and #2/29/08 The query runs and returns the correct data. However, I need the dates to equal 2 cells on a worksheet. I have tried using Between [ ] and [ ] as well as Between #[ ]# and #[ ]# but neither works. The sql shows the date criteria as Between {d '2008-02-01'} and {d '2008-02-29'} I have even tried to replace the '2008-02-01' and '2008-02-29' with [ ] and also with ? without success. What is the proper syntax to initiate the prompts so that I can set the parameters on cells on an excel spreadsheet? TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Passing Dates criteria in MS Query
Ok, it is now initiating prompts but I get an error message:
CLI0113E: SQLSTATE 22007 An invalid Datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007 I have tried numerous date formats, with and without #'s, 's, etc. without success in passing the dates. Again, I am querying db2 tables. I searched the net for CLI0113E and found the problem but not any solutions. Any Ideas? Thanks again. "Jim Thomlinson" wrote: You are correct with the square brackets but you need to add the prompt text between the brackets [Start Date] and [End Date] -- HTH... Jim Thomlinson "RW" wrote: I am trying to use MS Query to briong back data from DB2 tables. I have the query set up in the design view. I have several sets of criteria. Field1 = '1' Field2 = 'Y' Test Date Between #2/1/08# and #2/29/08 The query runs and returns the correct data. However, I need the dates to equal 2 cells on a worksheet. I have tried using Between [ ] and [ ] as well as Between #[ ]# and #[ ]# but neither works. The sql shows the date criteria as Between {d '2008-02-01'} and {d '2008-02-29'} I have even tried to replace the '2008-02-01' and '2008-02-29' with [ ] and also with ? without success. What is the proper syntax to initiate the prompts so that I can set the parameters on cells on an excel spreadsheet? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Query String into MS Excel | Excel Discussion (Misc queries) | |||
passing dates in a conditional sum(if) | New Users to Excel | |||
db query with dynamic criteria | Excel Discussion (Misc queries) | |||
query criteria question | Excel Discussion (Misc queries) | |||
Microsoft query criteria help | Excel Discussion (Misc queries) |