• Note: The date datatype can hold dates from Jan 1 of year 1 thru Dec 31, 9999. The datetime datatype can only hold dates from Jan 1, 1753 thru Dec 31, 9999

    Check your date column for values out of range of the datetime type.