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

You may use the method I mentioned above to add a new field to your LOV. When you create your dynamic paramter with datetime format, take the original datetime field as your value, the new field as description and set option 'Prompt With Description Only' as true. When you were prompted the datetime parameter, you will see the description only.

I think this is what you want.

Thanks