Insert A TimeStamp

[dandoescode]

I'm using Access 2010. I'd like to insert a timestamp into a field I thought

DoCmd.RunSQL ("INSERT INTO tempData (alteredDate) VALUES ( current_timestamp );")

would work, but I keep getting the Enter Parameter Value Dialog box. Anybody know what I'm doing wrong?

[John_G]

Hi -

What is current_timestamp? If it is a variable or a form field, it has to be outside the quotes. If you just want to get the current date/time, try using Now() in place of current_timestamp.

John

[dandoescode]

Thanks that worked excellently, I'd read on other forums that current_timestamp performed the same function.

[Missinglinq]

I'd read on other forums that current_timestamp performed the same function.

Not in other Access forums. current_timestamp is native to a number of SQL languages, I believe, but not Access SQL. It's seldom a good idea to assume that anything in Access is done as it is in other languages! There are many differences even between Access VBA and its parent language, VB6!

Linq ;0)>