Go4Expert - Adding date value in sql

Go4Expert (http://www.go4expert.com/)

- Visual Basic ( VB ) (http://www.go4expert.com/forumdisplay.php?f=22)

- - Adding date value in sql (http://www.go4expert.com/showthread.php?t=25161)

Adding date value in sql

When i try to add this field to a database in sql i get this error "Incorrect sysntax near 3

I know this is a simple error but i cannot figure it out

Code:

 cmd.CommandText = "insert into borrow (ISBNno, membername, Dateissued) values ('" & cbisbn.Text & "', '" & cbmember.Text & "', # " & DateValue(Now) & "#  )"