Date not saving in right format vb6.0, SQL server 2005

Question

I am trying to save this Date format in sql server 2005, all i get is 1/1/1900 12:00:00 AM the code is

 txtRent_Date.Text = Format(Now, "mm/dd/yyyy")

Answer 1

You need to put apostrophes around your dates, like this:

strsql = "INSERT INTO Rental_Copies(Rental_id,Copies_id,Rent_Date,Due_Date)" & _
         "Values(" & txtID.Text & "," & ListView1.ListItems(X + 1) & ",'" & _
         txtRent_Date.Text & "','" & txtDue_Date.Text & "')"

Like others have said, you should be validating your data before using it and parameterizing your SQL to prevent SQL injection.