System.FormatException: The String Was Not Recognized As A Valid DateTime. There Is A Unknown Word Starting At Index 0.

i cannot seem to get rid of this error. My page works in other functions that have the same syntax and format. just this one doesnt. i tried changing the format but still the same thing.


SQL DB is DateTime. Any Suggestions?








Function UpdateException(ByVal qID As String, ByVal exception_Status As String, ByVal completed As String, byval notes as string, byVal Username as string) As Integer


dim strDate as date = datetime.now()


dim strdate1 as string = strDate.tostring("MM-dd-yy")


Dim connectionString As String = "server='servername'; trusted_connection=true; Database='CPD_Reports'"


Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)





Dim queryString As String = "UPDATE [Master_CPD_Reports] SET [Exception_Status]=@Exception_Status, [Completed]"& _


"= @Completed, [Completion_Date]= @Completion_Date, [Username]= @Username WHERE ([Master_CPD_Reports].[QID] = @QID)"


Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)





sqlCommand.Parameters.Add("@QID", System.Data.SqlDbType.VarChar).Value = qID


sqlCommand.Parameters.Add("@Exception_Status", System.Data.SqlDbType.VarChar).Value = exception_Status


sqlCommand.Parameters.Add("@Completed", System.Data.SqlDbType.VarChar).Value = completed


sqlCommand.Parameters.Add("@Completion_Date", System.Data.SqlDbType.varchar).Value = strDate1


sqlCommand.Parameters.Add("@Username", System.Data.SqlDbType.DateTime).Value = UserName


dim NotesUpdate as string = "INSERT INTO [CPD_Notes] ([qID], [Notes], [Notes_Date], [Username]) VALUES (@qID, @notes, @Date, @UserName1)"


Dim sqlCommand1 As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(NotesUpdate, sqlConnection)


sqlcommand1.parameters.add("@qID", system.data.sqldbtype.varchar).value = qID


sqlcommand1.parameters.add("@Notes", system.data.sqldbtype.varchar).value = notes


sqlcommand1.parameters.add("@UserName1", system.data.sqldbtype.varchar).value = Username


sqlcommand1.parameters.add("@Date", system.data.sqldbtype.datetime).value = DateTime.now()


Dim rowsAffected As Integer = 0


trace.warn(strdate1)





sqlConnection.Open


Try


rowsAffected = sqlCommand.ExecuteNonQuery


Finally


End Try





dim rowsAffected1 as integer = 0





Try


rowsAffected1 = sqlCommand1.ExecuteNonQuery


Finally





End Try





Return rowsAffected


return rowsaffected1


sqlConnection.Close


End Function