By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 994 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

How to sort this

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.