Put the info in a "date" field and then everything will be sorted as if it
were a date. If you leave it as text then you will get a text sort (which is
what you are seeing now).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Eric Verstrepen" <er*************@pandora.be> wrote in message
news:df*********************@hebe.telenet-ops.be...
Hi there,
I have a colom with the next 'date' info
12/06/2003
15/05/2002
09/07/2004
If i sort this, i get the following:
09/07/2004
12/06/2003
15/05/2002
But that is not that i want. I want the following:
15/05/2002
12/06/2003
09/07/2004
Can anyone help me how to do this.
Thanks
Eric Verstrepen