Hi Maltin,

The 01/01/1900 is "empty" date because SQL Server stores all dates as offset from that date. It's common practice in SQL Server to use Null values to represent unknown/missing dates.

>I'am using a ADO to access the database and when I use the statement/command to insert a record like this;
>
>oRS = oCon.Execute("Insert Into Sample (Name, BDate, TranDate) Values ('Name', '01/20/1975', '')")
>
>then when I view that record the TranDate has a value of 01/01/1900 how can I control that I want the TranDate to be empty not 01/01/1900.
>
>Is there a way that an empty date should store an empty date instead of 01/01/1900?