Hey Andrew,

Thanks for the information...I'm conducting a backup and restore of the database as we speak...I think may be the answer. Thanks

Ryan

One possibility is that there is a column that has all date fields with format mmddyyyy and every data is entered as (1/1/1900).  I may ask the DBA to delete...

Remi,

Thanks for your help!!

Ryan

I may have to check with one of the DBAs since I'm not able to review the design from my local station.

Remi,

From looking at the design of the table, the min a max value is

datetime: betwen 1753/01/01 and 9999/12/31.

Thanks

No...I don't think the values are before that date format. I've checked the original table also...but everything okay!! weird.

Ryan