Problem with function Date() in SQL in VB

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³
 
K

Kevin K. Sullivan

How about

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

HTH,

Kevin
 

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

SQL Not Working 5
Need Help with Macro Security 1
Compile Errors 2
Problem with Function Date() in query 1
Problems created by Recent updates to Outlook 365 0
Excel - Wich Function should I use? 1
Error Problem 5
query issue 2

Top