date error using Visual Studio 2005 - report designer error 8114 RRS feed

  • Question

  • Hi,
        I am just learning to use Visual Studio 2005.  I have written a stored procedure that is looking to accept a date variable
    ALTER  PROCEDURE SickLeaveRpt @pay_ref varchar(5),
                                                      @person_date  datetime                                                                                             I have gone into visual studio 2005 and created a new report with dataset query string of  
                  exec SickLeaveRpt @pay_ref, @person_date 
    and also defined the parameter in report parameters as datetime
    when I enter the date in as DD/MM/YY (as I am in Australia) I get the following error
        an error occurred while executing the query. error converting data type nvarchar to datetime

    what am I doing wrong??
    Wednesday, April 1, 2009 4:43 AM