>Including a made up date is not a solution it is a work around and is not acceptable to my superior. I have suggested it. The problem is the product is developed by a Third party Best Software ABRA HR. So I may not be able to modify their data structure. There Consultant told us to leave that field blank when we are writing out our data from the mainframe. Is it Possible to omit the field from the Insert Into Clause?
You cannot write empty dates into VFP table through VFP ODBC driver because ODBC driver doesn't have concept of empty dates. It will convert empty dates into 12/30/1899.
You can ommit date filed from your insert but it wouldn't do any good. If VFP ODBC Nulls option is set to Yes than ommited fields will be treated as Nulls. Otherwise they'll be treated as empty and empty dates will converted into 12/30/1899.
--sb--