>Its working I turned on century to on and it changed everything to xx/xx/2000 that were xx/xx/00 in my table and my text fields.
>thanks kelly

That's great. But be aware that SET CENTURY is scoped to the datasession, so that if your forms use Private DataSessions, you need to be sure you specify your SET CENTURY commands in the DataEnvironment BeforeOpenTables method or in your Form's Load method.