[RESOLVED] SQL Server Date Insertion Error

Hello,
i have a sql server table where the date field in the table is set to smalldatetime.

i get an error when i try to insert Date.Now() into the field.

When i use Date.Today() to insert the date in the field sets itself to 01/01/1900
even thought the day is todays date.

why is the date setting itself to 01/01/1900

also why cant i insert a full date and time into the small datetime field

Try

VB Code:

FormatDateTime(DateTime.Now, DateFormat.ShortDate)