Date insertion problem in ASP.Net
I am trying to insert the date in SQL Server database but the thing inserted is 1900/1/1 12.00 etc.
How can i insert the read date in the database.
the code is given below.
Dim RlDate As DateTime
Try
RlDate = CType(cmbRLYear.SelectedItem.Text & "/" & cmbRLDay.SelectedItem.Text & "/" & cmbRLMonth.SelectedItem.Text, DateTime)
lblTest.Text = RlDate.ToString
InsertCmd.CommandText = "Insert into tblLetters(RLNo,RLDate,RLSubject) values(" & Me.txtRLNo.Text & ",'" & RlDate & "','" & Me.txtSubject.Text & "')"
InsertCmd.Connection = Session("LMSConn")
InsertCmd.ExecuteNonQuery()
Me.lblTest.Text = "Record Saved"
Catch ex As Exception
lblTest.Text = ex.Message
End Try

