How to sort this

[Eric Verstrepen]

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

[Michael \(michka\) Kaplan [MS]]

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