>Hi,
>
>Naomi,
>
>your solution does not work : Error 11 (function etc invalid)
>
>Regards,
>
>Koen
Koen,
I see the problem now. We need DTOS(CTOD(Field3)) In other words, we need to first convert character expression to date to use DTOS function to sort it correctly.
Also field2 and Field1 should be the same length for this to work correctly. Otherwise PADR to the longest length.
If it's not broken, fix it until it is.
My Blog