[RESOLVED] how to insert null date

[viperbyte]

Hey everyone. I have some date fields that I want to not have any dates during a record creation. I figured the way to go would be to insert NULL. The way I'm going about it now gives me a Type mismatch error. How do I go about doing this? VB 2008 Standard/Access 2007

  command.CommandText = "INSERT INTO IssueTbl(HardwareID,SoftwareID,Description,OpenedDate,AssignedDate,ClosedDate) " & _
           "VALUES('" & selHardware & "', " & _
           "'" & selSoftware & "', " & _
           "'" & Me.txtDescription.Text & "', " & _
           "'" & Now & "', " & _
           "'" & DBNull.Value & "', " & _
           "'" & DBNull.Value & "')"