Re: Strange error with date field (Online 5.01)

I remember once having the same sort of problem with corrupt dates where things made no sense; however, i forget how i corrected it. Try updating the date to a valid date with the between clause: update edomorg set opdate="19.09.96" where opdate between "19.09.96" and "20.09.96" since they get selected, they should get updated(hopefully), otherwise you may have to unload and/or reload the table. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***