Date in a sql table

A

alvin Kuiper

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
 
B

Barry Gilbert

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
 
Top