*FUNCTION todate LPARAMETERS tcDate, tcFormat LOCAL lcFormat, ldDate, lcDate ldDate = Null lcFormat = UPPER(ALLTRIM(tcFormat)) DO CASE CASE lcFormat = "YYYYMMDD" lcDate = tcDate ldDate = EVALUATE("{^" + TRANSFORM(lcDate, "@R 9999/99/99") + "}") CASE lcFormat = "YYMMDD" lcDate = LEFT( STR( YEAR( DATE()),4),2) + tcDate ldDate = EVALUATE("{^" + TRANSFORM(lcDate, "@R 9999/99/99") + "}") OTHERWISE ENDCASERETURN ldDate