>>"2002/01/23"
>>
>>to this?>>"01/23/2002"
>>
>>It actually starts out as this:>>"20020123"
>>
>>If that matters.>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.