Date in a sql table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I use thsi code
rs.Open "update tilmelding set behandlet = 1, behandler = '" &
ReturnUserName & "', behandletdato = " & Date & " where behandlet = 0 ",
Cnxn, adCmdTable

But behandletdato gets not the value off date
just now the value is 03-07-1894

CAn seomeone help here ?

Alvin
 
I think you need to surround the date value with # signs.
rs.Open "update tilmelding set behandlet = 1, behandler = '" &
ReturnUserName & "', behandletdato = #" & Date & "# where behandlet = 0 ",
Cnxn, adCmdTable

Barry
 
Back
Top