SQL Server doesn't have empty dates. It's better to allow nulls for dates that may be unknown/not filled in.

>Im inserting into SQL from Fox using Pass through. Fox has empty Dates {//}. if I use CAST('' AS DATETIME) I get a default datetime 1900-01-01 00:00 ext in SQL. The Date in SQL does not accetp nulls. Can I get SQL to CAST() an empty Date? OR, should I allow SQL date column to accept nulls? I usally allow nulls in cretain columns.
>
>Your input is appreciated.
>Regards
>Jeff Hart