Try following (I used '{}'):
SQLstmt = "INSERT INTO RESULTS (Entrydate)
SQLstmt = SQLstmt & " VALUES ("
SQLstmt = SQLstmt &"{" &EntryDate &"}"
Set Rs = objConn.Execute(SQLstmt)
HTH.
>Hi, I am trying to insert a record to a foxpro freetable via web with .asp and all goes in except the date...I'm stumped..any ideas on what I am doing wrong??
>
>
>Here is the string
>
>Dim EntryDate
>entryDate=Date
>SQLstmt = "INSERT INTO RESULTS (Entrydate)
> SQLstmt = SQLstmt & " VALUES ("
> SQLstmt = SQLstmt &"'" &EntryDate &"'"
> Set Rs = objConn.Execute(SQLstmt)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.