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

CA Forum: General

Create your param as a date only, and add the time in your select formula

{Field.D_Time} in {?date_only} + time(00,00,00) to {?date_only} + time(23,59,59)

This will give you the entire day, between the hours specified, for the Field.D_Time

This should work just fine.