Hi Jay,

UPDATE: Looks like Rich's way is easier.

this will work if you can guarantee the format.

  aaa="20020123"
?DATE(VAL(LEFT(aaa,4)),VAL(SUBSTR(aaa,5,2)),VAL(RIGHT(aaa,2)))

>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.