odbc empty date field

[ultimatewilliam]

i've created an odbc data source to connect to my old foxpro database and wrote a small program in vb that uses this data source. but when it finds that a date field is empty or has no value, it gives December 30, 1999. how do i prevent this to happen? thanks.

 

[LazyMe]

You could check it for a NULL value and act upon that.
Greetings,
Rick

 

[ultimatewilliam]

thanks, but these records are being retrieved thru a recordset, so if i have "select * from mytable" some empty dates are not actually empty.