Just take 6 last (right) digits from DTOS() without any extra function.
>
> CASE EligCrit.FormatVal = 'YYYYMMDD'
> NewFieldValue = DTOS(FieldValue)
>
> CASE EligCrit.FormatVal = 'YYMMDD'
> NewFieldValue = RIGHT(DTOS(FieldValue),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?
If it's not broken, fix it until it is.
My Blog