Stored procedure & Crystal Report 11.

I have stored procedure with Datetime as a input parameter that stored procedure call in crystal report 11. When I try to run the Crystal report it prompt me to enter yyyy-mm-dd hh:mm:sc, is there any way it prompt me for date only like yyyy-mm-dd only ?

Thanks
NOOR

I edited the file C:\Inetpub\wwwroot\aspnet_client\system_web\2_0_50 727\crystalreportviewers115 \prompting\js\promptengine_calendar.js. There is a variable DateTimeFormat=true at the top. I set this to false and it still returned the datetime. I ended up commenting the part of the date return function that adds the time. I don't plan on ever returning a datetime from the calendar popup. That worked. It still says enter the datetime format in the prompting text. I will hunt around for that later.

Change the client validation for datetime to the same as the date in file C:\Inetpub\wwwroot\aspnet_client\system_web\2_0_50 727\crystalreportviewers115\prompting\js\prompteng ine_prompts.js. Otherwise, it asks for the datetime format when you click OK.