Dear All,

I am trying to insert a Date value to a table in SQL2000 using the following sql code but it's geving me an error

insSql = "INSERT INTO an_paymenthdr (PaymentDate) VALUES('" & Date.Today & "')"
Dim insCMD As New SqlCommand(insSql, myConn.oAdoNetSql_Conn)

But it accept it on the following code

insSql = "INSERT INTO an_paymenthdr (PaymentDate) VALUES('15/01/2003')"
Dim insCMD As New SqlCommand(insSql, myConn.oAdoNetSql_Conn)

Any idea please