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: qcheng

CA Forum: General

Hi Esc2Xtc,

I meant that you need to edit your stored procedure using the method I mentioned. The converting the datetime field to a text field for parameter display purpose only should have been complated in SQL server BEFORE your Crystal report linked to the stored procedure. Your parameter field in the stored procedure is the converted text field, rather than the datetime field.

Thanks