My understanding of the SQL database is that a date field in VFP is actually a datetime field in SQl Server. (SQL Server doesn't support a DATE field.) Also, due to the DATETIME field limitations, they cannot be empty. They will probably accept NULL values, but that's the absolute closest you'll get.

Also, keep in mind, that as a DATETIME field, when you query SQL Server, it will come over as DATETIME, and you will therefore probably need to make changes in your program accordingly.

>I am upsizing a Visual foxpro table to sql using the wizard
>
>empty date fields from fox are being populated in sql as
>
>01 jan 1900 12.00 am
>
>how do I prevent this happening ?
>
>help