>I have a .dbf free table that has dates as 01/01/06. This seems to be causing a "database engine failue" when I use this dbf as my data source in a Word Mail Merge. (I selected dbase files). I know the fix is to SET CENTURY ON in the code before creating the .dbf. But how do I converted my 01/01/06 to 01/01/2006 in my existing .dbf?
>
>Brenda

Try converting the date field to a character and back with SET CENTURY ON

Something like this:

SET CENTURY ON

UPDATE <table>
   SET <datefield> = CTOD(DTOC(<datefield>))