General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only