>I am trying to convert some data from a Foxpro table to a sql database. One of the fields is a string time field in Foxpro (09:15) and a datetime field in sql. I am using the DateTime.Parse() command to convert the string values to datetime values. Everything is working fine until I hit a field that is blank. How to I generate a blank, null.... what every the correct word is, value to insert into the sqltable? In Foxpro DTOT({}) would give me a blank datetime variable.
The following returns an empty date:
Public Function GetEmptyDate() As Date
Return New Date(1899, 12, 30, 0, 0, 0)
End Function