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 ), '/', '' )
>