>>>Is there a simple way to convert this:
>>>

>>>"2002/01/23"
>>>

>>>to this?
>>>

>>>"01/23/2002"
>>>

>>>It actually starts out as this:
>>>

>>>"20020123"
>>>

>>>If that matters.
>>
>>How about

>>ab="20020123"
>>SET CENTURY on
>>SET DATE american
>>? CTOD(TRANSFORM(ab,"@R ^9999-99-99"))

>
>How can I work that into this?
>

>NewFormatValue = EVALUATE("ALLTRIM(TRANSFORM(CHRTRAN(FormatValue,CharactersToStrip,''), '@R ####/##/##'))")
>

>Where FormatValue is:
>

>"20020123"
>

>I'm not trying to get the date, but rather the text value.


To get the result as a character string (I missed that part of it) you could modify it to

>>
? DTOC(CTOD(TRANSFORM(ab,"@R ^9999-99-99")))

To work it into your line of code how about something like..........

? DTOC(CTOD(EVALUATE("ALLTRIM(TRANSFORM(CHRTRAN(FormatValue,CharactersToStrip,''), '@R ^####/##/##'))")))