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

Thanks for your response to my query.

#1 As you can see from my previous post, I cannot select "Date". This has been disables by Crystal Reports. Is there any way to re-enable it?

#2 I tried what you specified. Here are the steps I tried

[To modify Field formats under File --> Options --> Fields --> Date and Time button --> Date and Time tab --> Customize button -->

Set Order = Date --> Select OK to Save.]

Date Time is still displayed in parameter selection than date.

However even if this works, it might not be a feasible solution since I would need to go around to each users desk changing this setting?

Would appreciate any other advice you could send me. Thanks.