Thank You Michel
Scott
>>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:
>
>
> ' Return an empty date
> ' expT1 Date
> Public Function GetEmptyDate() As Date
> Return New Date(1899, 12, 30, 0, 0, 0)
> End Function
>