I have a field set as Datetime and i have a variable that gets todays date... when i try to insert the date i get this error..

System.Data.OleDb.OleDbException: Syntax error converting datetime from character string.

Here is my code

VB Code:
  1. Imports System.Data.OleDb
  2. Public Class WebForm2
  3.     Inherits System.Web.UI.Page
  4.     Dim Conn As OleDbConnection, Command As OleDbCommand, DataRead As OleDbDataReader
  5.  
  6.  
  7.     Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  8.         Dim Title As String, Teaser As String, Full As String, TheDate As String
  9.         Title = Request.Form("txtTitle")
  10.         Teaser = Request.Form("txtTeaser")
  11.         Full = Request.Form("txtFull")
  12.         TheDate = CDate(Date.Today.ToString)'Todays date i.e... 6/20/2003
  13.  
  14.         ExecuteQuery("INSERT INTO tblNews (NewsTitle,NewsTeaser,NewsFull,NewsDate) VALUES ('Title','Teaser','Full','TheDate')", "Test")
  15.  
  16.         Conn.Close()
  17.  
  18.     End Sub
  19.     Public Sub ExecuteQuery(ByVal SQL As String, ByVal DB As String)
  20.         If Application("Connection") Is Nothing Then
  21.             Try
  22.                 Conn = New OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings.Get(DB))
  23.                 Conn.Open()
  24.                 Command = New OleDbCommand(SQL, Conn)
  25.                 DataRead = Command.ExecuteReader(CommandBehavior.CloseConnection)
  26.             Catch ex As Exception
  27.                 Response.Write(ex)
  28.             End Try
  29.         Else
  30.             Response.Write("Couldn't execute Query, Already Connected. Close the connection and try again.")
  31.         End If
  32.     End Sub
  33.  
  34. End Class

I dont domprendeh why it's saying it cant convert the date



Thanks!