Date insertion problem in ASP.Net

Dear members
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
[895 byte] By [sajjo] at [2007-11-19 23:39:55]
# 1 Re: Date insertion problem in ASP.Net
hi
I think you have prolem with date
so use
date Formate string to convert date which you want
like in VB.Net

dim todate = String.Formate("{0:dd-mm-yyyy}",now.date())

and insert todate in database
VasantG at 2007-11-10 3:30:22 >