Insert timestamp in asp

  • Thread starter Thread starter Dave
  • Start date Start date
D

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 & "'
 
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
 
How do I set it to default?

Is this accomplished in the Insert syntax?

The code is big!
 
Back
Top