Hi Tom! How're things in Michigan? First off, make sure you have SET DATE SEQ MMDDYY. You must have had MMDDYYYY somewhere.
I looked at my help notes and got this command: UPDATE tablename SET datecolumn = (datecolumn + ( '1/1/1980' - '1/1/0080' )) WHERE datecolumn < '1/1/0100' Karen > Good Morning all, > > I know it is an easy change to make, but I sure can't remember how to do it. > > My default dates are registering as 0008 rather than 2008 ... where and how > do I adjust the century? > > Thank you > > Tom Eldred > >
