aaa="20020123" ?DATE(VAL(LEFT(aaa,4)),VAL(SUBSTR(aaa,5,2)),VAL(RIGHT(aaa,2)))
>"2002/01/23" >
>"01/23/2002" >
>"20020123" >