Hi Mark in SQL Server you cannot have blank dates if you don´t want any values then you should put the date field to null if you do this don't forget to put the field as allow nulls.
>Hi all,
>
>I am connecting to tables on SQL Server 7 through remote views. The problem I am having is with dates, they default to 1/1/1900.
>So after I add a record this appears, ideally I want this to be blank(that same as a foxpro table) if there is no users input.
>
>Can anyone give me advice on solving this problem, is there something I can change in the server???
>
>Cheers
>Mark
Alexandre Palma
Senior Application Architect