Search results for query: *

Oh one more thing. I have added other prompts to this same query. The input values of these are not dates, but they work just fine. I have removed them and hard-coded their values temporarily to ensure they don't conflict with 'my PRECIOUS' date prompt. I wonder if there is some kind of glitch...

Hi.. Yes, it does work if I hard-code it, but since the users do not have SQL access, I was trying to empower them a bit. thx!

Hi blom0344 - I have also tried that format. What I hadn't tried was the @variable. @Prompt has worked in the past for me using other types of values and simple dates, but not this time. I just tried the '@variable', but no 'workie'. :( I get the same response. Thanks for your response! :)

Hi Steve! Thanks for the response. I started off with 'D' and moved to 'A' because I was getting the 'no data to fetch' message. I don't know what format it expects. I've tried every possible combination I can think of. At this point, I am assuming that it just doesn't like the prompt...

Hello... Help! :( (Using Business Objects Full Client 6.52 and Oracle 10G - REAL-TIME data) I am having trouble with my prompt. :( I keep getting 'no data to fetch'. (ORDERS.ORDER_DT Between @Prompt('Start Date','a',,mono,free) AND @Prompt('END Date','a',,mono,free) ) I can get it to work...