Im making a little program to track outstanding service work for a company in Visual Basic with a SQL Server 7 database. Ive run into some trouble trying to pass a date to the database and get a : "[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime" Here is my code, the Finished variable is a text box which is formatted to a date variable. Then it is passed as a date variable throughout my various tiers. Presentation Layer (checking which radio button is pushed and entering a date if yes is selected) Business Layer Data Access Layer SQL Procedure ANY HELP ?????