I created a stored proc that has input datetime parameters (begindate and enddate), I tried the command: exec storedproc '20060320' in the query command part in Microsoft SQL Server Management Studio and it works but when I try to create a report dataset using the stored proc and execute it using value 20060320 it does not work. I even try using '20060320' and "20060320" as the value and it did not work also. I received the following error:
TITLE: Microsoft Report Designer
An error occurred while executing the query.
Failed to convert parameter value from a String to a DateTime.
ADDITIONAL INFORMATION:
Failed to convert parameter value from a String to a DateTime. (System.Data)
String was not recognized as a valid DateTime. (mscorlib)
BUTTONS:
OK
Anyone have any idea on how can I solve it or go about it? Thanks in advance.
Daren
Try using the format: "mm/dd/yyyy", so it would be: 03/20/2006.|||Thanks Deepak,
This solved my problem.
Daren
No comments:
Post a Comment