Hi experts,
I need to use DatePicker at Paramter Fields. If I use it as datetime in sproc code, DatTimePicker comes up at Parameter Fields of Crystal Reports. But I would like to use it as date. If I change @startdate as datetime to @startdate as date, DateTimePicker icon is gone. How can I solve this problme?
Thanks,
David
ALTER PROCEDURE [dbo].[usp_My_SPROC]
-- Add the parameters for the stored procedure here
(
@startdate as datetime,
@enddate as datetime,
@loc int
)
AS
SET NOCOUNT ON