I am trying to post a date from asp to a foxpro database. I keep getting an "Invalid Data Type" error. The field is formatted as a date field in foxpro. Can anyone help me to resolve this? Here is a sample of the asp code (very simplified):


today = now

Set Conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=test"
SQL="INSERT INTO foxtable(date) Values (" &_
"'" & today + "')"

Set RS = Conn.Execute(SQL)
set rs=nothing