I have the following code:
Unfortunately, it writes "01/01/1900" to the database. How do I get it to just leave the field as NULL?Code:If Trim(txtConfirmationDate.Text) <> "" Then
sqlinsert2.Parameters.AddWithValue("@CONFIRMDATE", CDate(txtConfirmationDate.Text))
Else
sqlinsert2.Parameters.AddWithValue("@CONFIRMDATE", VB.vbNull)
End If

