Problem with function Date() in SQL in VB

  • Thread starter Thread starter Rafa³
  • Start date Start date
R

Rafa³

I have this code:

DoCmd.RunSQL "UPDATE tmp SET tmp.DataZm = Date()"

But I got the error 3075:

"Function can not be used in query"

Can anybody help me?

Rafa³
 
How about

DoCmd.RunSQL "UPDATE tmp SET tmp.DataZm = #" & Date() & "#"

HTH,

Kevin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Function Date() in query 1
SQL Not Working 5
Compile Errors 2
sql query help 3
Problems with deleting 2
Access 2003 1
Environ('USERNAME') error 1
DoCmd.RunSQL who could check my sql? 8

Back
Top