at first look there doesn't seem to be a syntax error in your code, but saying that the code that frontpage generates for ASP is diiferent. I wouldn't be able to tell you if this part of your SQL is correct:
I would love to help you further but i need to know what error was generated, did you get an data type miss match error?
If your database field is of text type then your syntax is wrong, but if it is date/time type then i would write the SQL statement out to screen to check what values are being submitted.
Just comment out all the working for the SQL after the statment and your execute line. Put in the following
now you should see the sql query on the screen.
Your date should be displayed. Now you are looking to see if your date is being displayed like one of the following:
so depending on your field in your database one of these will be correct. Also forgot to ask is it Access or SQl Server or another database you are using, again this will effect the syntax