Try to change the column type to datetime.
>They are still all in range
>
>>Oops, the range I provided was for datetime, For smaldatetime its January 1, 1900, through June 6, 2079.
>>
>>>The dates are all in range
>>>
>>>>The smalldatetime data type supports dates from January 1, 1753 and up. Check you data for dates that are out of range.
--sb--