Jan 9, 2002 #1 sepia Programmer May 18, 2001 26 0 0 US I'm trying to produce a report that has a stored procedure running behing it. I'm getting the following error: ODBC error:[Micrsoft][ODBC SQL Server Driver][SQL Server] Error converting data type varchar to smalldatetime Can anyone help? Thanks.
I'm trying to produce a report that has a stored procedure running behing it. I'm getting the following error: ODBC error:[Micrsoft][ODBC SQL Server Driver][SQL Server] Error converting data type varchar to smalldatetime Can anyone help? Thanks.
Jan 9, 2002 #2 Devcon5 Programmer Oct 11, 2001 4 0 0 AU it seems the SQL statment u have to retrieve data from the DB invloves a Date field in the where cluase. .eg where mydate = "10/01/2002" the value "10/01/2002" in your case doesnt represent a validate date.. hence you get an error.. make sure the date value "10/01/2002" is a validate date.. cheers CJ Upvote 0 Downvote
it seems the SQL statment u have to retrieve data from the DB invloves a Date field in the where cluase. .eg where mydate = "10/01/2002" the value "10/01/2002" in your case doesnt represent a validate date.. hence you get an error.. make sure the date value "10/01/2002" is a validate date.. cheers CJ