Insert timestamp in asp

[Dave]

I keep getting a Syntax error in Insert Statement, regarding a timestamp.

Can you help with the syntax.

The DB is Access

The code is myTimestamp = now()

the insert statement is #" & myTimestamp & "#

I have tried '" & myTimestamp & "'

 

[Bob Lehmann]

What is the error? Show your *whole* query.

Why not set the field to default to the current date instead of inserting
it?

Bob Lehmann

 

[Dave]

How do I set it to default?

Is this accomplished in the Insert syntax?

The code is big!