Skip to Content
0
Former Member
Dec 14, 2011 at 07:14 PM

DatePicker instead of DateTimePicker

86 Views

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