Need Help! Creating a new report from SQL Server using parameters.

[vbboy]

I have to design a CReport using SQL Server's stored procedures which have two date data type parameters - Start Date and End Date. When I try to select the Stored Procedure from the list I get the Stored Procedures Input Parameters Box with yyyy-mm-dd hh:mm:ss.fff value But when I put a date value I get error message Parameter Number 1 is invalid.

Any help in this regard will be highly appreciated.

Thanks in advance

 

[dcm]

vbboy: You've got a DateTime or a DateTimeString field as the receptor for your input. You'll need to determine whether or not to put your response in quotes - try it - and you'll need to provide values for all elements David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[vbboy]

DCM, Thank you for help. I tried but it did not work.

Here is situation:

@StartDate yyyy-mm-dd hh:mm:ss.fff
I put '2001-02-01 01:01:00.000'

@EndDate yyyy-mm-dd hh:mm:ss.fff
I put '2001-03-01 11:59:00.000'

But I got same error message.
Parameter Number 1 is invalid

Thanks again.

 

[bessebo]

I would try to enter this date for your start date:


DateTime(2001,02,01,01,01,00)

and this for your end date:

DateTime(2001,03,01,11,59,00)

Regards,
Bessebo

 

[anhmytran]

Have you tried CONVERT function?