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 Qingping,

In response to a query with the above subject, you mentioned that you created a scalar-valued function in SQL Server to convert the datetime field to crystal parameter date.

Can you please clarify how you did this? I am facing the same problem and am begining to believe that this is a Crystal Report limitation since no amount of research gives me a solution. Thanks !

~X