That message means that there's a row of data where there's something in there that is NOT an actual date. It doesn't refer to the defintion of the column itself. Usually this happens when there's corruption in the column. You'd see it as having those funny extended characters in there rather than an actual date.
karen > Paul, > Wasn't aware that this note had an attachment. Strange.... > > I unloaded and reloaded the table. Upon reload I got an error, > ERROR- Column duedate must be a valid DATE. ( 122) > Odd to me because duedate is defined as a date. The other date > fields didn't give me an error. > > In addition when I print my monthly 140 records to disk, the > duedate field prints as mm/dd/yyyy > > It loads without any date error. I tried it from the R> prompt > with error messages and echo on
