Hello,

I have a stored procedure that inserts records into a table. There is a date field, and the value I want to insert is 3/26/3005 but I can't. I assume it is because of the 3005 year, because when I change it to 2005 it works correctly. I am pretty sure this is a typo at the source.

I know it is a poor programming practice to allow bad data, but I can't control the source and what they enter, and I don't want my application to blow up everytime there is a type like this. Is there a way I can allow the 3005 year to be inserted?

Thanks,
MAC