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]]

Re: How to sort this

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" <eric.verstrepe n@pandora.be> wrote in message
news:dfbjc.989$ gz2.194621648@h ebe.telenet-ops.be...[color=blue]
> 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
>
>[/color]