>>>"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"))>
>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.eval(transform(ab,"[^9999-99-99")+"}")And you can simply put your FormatValue instead of ab and that'd be it - and Set Date independent too. The eval() would return a date value, which you can then output any way you like.