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) & "#  )"