>>>>
>>>
>>>It means that date is out of the allowed range: from January 1, 1753 through December 31, 9999.
>>
>>I don't think I have dates outside this range. Most likely, either my table is corrupted or the date is empty. I will check all fields.
>
>An empty date is outside of the range.
My SQL Server smalldatetime field allows NULLs. Do you know if I set value to ".NULL." it will work (for those records where date is empty)?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham