Sql Dates

[topgunf25]

I am new to SQL Server, currently trying to convert a Large 500K lines of code, from VFP to SQL Server.

Anyone know how to make the default of the date field to be
{//} empty instead of 01/01/1900?

I could write a something to change the data as it comes in, but that ugly.

 

[tlbroadbent]

In the table design mode set the Default to NULL. Make sure you allow NULLS in the column. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm