Now() - ASP

[mainmast]

How would I put Now() in a insert statement as a value? I've even tried putting it in a variable and then placing the variable in the insert statement, but it doesnt work. Could anyone help me?
Thanks in advance

[kabatak]

are you talking about SQL insert ?

[Ajiang]

I encountered it sometimes.

[ashben]

Assuming that your database has a corresponding DateTime field, this should work:

sql = "insert '" & Now() & "' into YourTable"

The important thing is to wrap the DateTime stamp in single-quotes.

Hope it helps.