>>{^2005/10/13} >> >> CASE EligCrit.FormatVal = 'YYYYMMDD' >> SET CENTURY ON >> NewFieldValue = STRTRAN( DTOS( FieldValue ), '/', '' ) >> >> CASE EligCrit.FormatVal = 'YYMMDD' >> SET CENTURY OFF >> NewFieldValue = STRTRAN( DTOS( FieldValue ), '/', '' ) >>>
CASE EligCrit.FormatVal = 'YYYYMMDD' NewFieldValue = ALLTRIM(TRANSFORM(DTOS(FieldValue), '@R 99999999')) CASE EligCrit.FormatVal = 'YYMMDD' NewFieldValue = RIGHT(ALLTRIM(TRANSFORM(DTOS(FieldValue), '@R 99999999')),6)But it seems like I shouldn't need t use the RIGHT on that. Am I missing something with the TRANSFORM, or is this acceptable?