Datetime To Date Parameter issue...

[Former Member]

Post Author: ram323

CA Forum: General

How can I convert the parameter from Datetime data type to Only Date Parameter so that everytime the parameter prompt window pops-up, the user will only input the Date and not seeing the Time on the parameter prompt window..I am using Crystal Reports XI..and my stored procedure uses DateTime data type....Need Help!!! a step by step procedure will be greatly appreciated.....Thanks much....

[Former Member]

Post Author: Esc2Xtc

CA Forum: General

Hi qcheng,

Many thanks for taking the time out and sending in your solution.

Unfortunately this might not help me.

Correct me if I am wrong, but what your solution seems to be doing is converting the datetime parameter to a date value AFTER it has been entered by the user and after crystal reports sends it to SQL.

Rather what I need is some method to display ONLY A DATE prompt to the user in crystal reports without the time part. Management does not want the user to see the time field at all in crystal reports when entering a date.

Is this possible at all when linking crystal reports to SQL stored procedures with datetime parameter field?

Thanks.