Passing a date time to a report through a prompt

[KidFix]

ello

how can I pass a date time into a report prompt?

I've already tried:

prompt0=01/01/2004 00:00:00

and

prompt0=DATETIME(2004,01,01,00,00,00)

with no success. Any help would be greatly appreciated

 

[pgtek]

hi

If you want to do this
create parameter that will prompt user to insert date

cheers



pgtek

 

[KidFix]

the report uses a stored procedure that requires two date parameters to be inputted so if nothing is passed to the report on opening it automatically prompts the user to input the dates, this isn't what I want it to do however, I want to pass the report the two dates in the query string so the user doesn't have to input anything. The problem is I can't work out what format the date time needs to be in when it is passed in the query string