Pass Prompt Value to Native SQL variable

[jshamm]

Is there any way to pass a date prompt to a native SQL variable?  As a test I have this simple code:

DECLARE @DatePrompt as datetime

set @DatePrompt = #sq(prompt('paramDate', 'datetime'))#

SELECT @DatePrompt

This does not work when I put it in a report studio query, though.  I get "The server returned an unrecognizable query framework response".  Is it possible to pass a prompt value to a SQL variable?

[kc9400]

SELECT name, date, example
FROM database.database
WHERE date = (#prompt('prompt name')#)

For IN would be WHERE date IN (#promptmany('prompt name')#)

I think this is what you're after?