index on substr(date,5,2)+substr(date,3,2)+substr(date,1,2) to temp descending
copy to x

>Hi all,
>
>I have a table with a character field which contains a date in this format: ddmmyy (Example: 110605) [June 11 2005] Now I want to sort the table with the youngest date in the top. How can I do that? When I do like this:
>
>sort on substr(date,5,2)+substr(date,3,2)+substr(date,1,2) to x descending
>
>I got an error message. Can anybody help me with this problem?
>
>Thanks in advance
>Ron