>I have a character field with a date stored in it in the following format
>
>mm/dd/yy
>
>I need to get this to be in this format ccyymmdd
>
>any suggestions?

Well... how do you know what the century is? You can use CTOD(). OR, the 6.0 Date function in 6.0 may be better.

BOb