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