They do make you jump through some hoops, but I think I’ve got it worked out.
Dim dYourDateField As Nullable(Of Date)
…then you either set it to be a date (using DateSerial or CDate or whatever, or you set it to Nothing.
Then when you’re using it in a database query, the parameter can be set like this:
oCmd.Parameters.Add(“@YourDateField”, System.Data.OleDb.OleDbType.DBDate).Value = dYourDateField
That’s it. At least, it seems to work okay for me. Touch wood. Apparently it should be okay in the .Net Framework 2 onwards.
[Another in an occasional series of things Daniel posts about so he can easily re-discover it next time he needs to remember how it’s done.]