date in accesstable

[Mitre]

i got error for the following code... any idea wats wrong?

dim date
date=date()

SQL="Insert INTO Table (date) VALUES(date)"
Execute.Con(SQL)

[Mitre]

jus ignore this.. found the problem... which is we cannot name the field as date.. since its a keyword