Need help with this simple sql statement

Need help with this simple sql statement

am 01.05.2005 10:54:45 von jill

I am trying to store the current date to an ms access database on my server.
I set it up with a dsnless connection.
Here is the statement:
Insert Into employees(timestamp) Values ('" & date() & "')"

the timestamp field is of type date/time in the ms access database.

I get an error saying the insert statement is invalid. Cannot get you the
exact error, my server is down.
But it seems that the syntax is correct.

Please advise

thanks