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
 
Back
Top