DTOS() function always returns 4 digits for the year regardless on the CENTURY settings otherwise how would we use DTOS in indexes? You need to use different TRANSFORM functions.
>These two CASE conditions return "20051013" as the NewFieldValue, regardless of the CENTURY setting. It is a function in a SQL statement column, if that matters.
>
>The value of FieldValue is:
>
>{^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 ), '/', '' )
>
If it's not broken, fix it until it is.
My Blog