I'm calling a stored procedure in my crystal report.
It has one of the Input Parameter P_date as DATE datatype.
In CR, I clicked on the P_Date and check the valuetype option in Edit parmeter Screen its defaultly showing DATETIME.
Its not allowing me to select only DATE format. Even the dropdown is not enable to select the format.by default its showing datetime.
I need to pass either (i) only Date without time OR (ii) Date with HH24:mi:ss , this will allow the user to enter AM/PM time in 24 hours time.
Could some one advice me as soon as possible how to set either of the above optoins. I have to put a quick fix.
Kindly let me know if you need more information.
Thanks for your time.