List View Sort order 
Author Message
 List View Sort order

How can sort a date properly in a list view when a user
clicks the column header.  Currently it sorts
ascending/descending, but it sorts the dates as strings.
for exapmle: 1/1/1998
             1/1/1999
             2/1/1998
Any suggestions?

Chris



Sun, 21 Mar 2004 02:27:39 GMT  
 List View Sort order
On Tue, 2 Oct 2001 11:27:39 -0700, "Chris Cox"

Quote:

>How can sort a date properly in a list view when a user
>clicks the column header.  Currently it sorts
>ascending/descending, but it sorts the dates as strings.
>for exapmle: 1/1/1998
>             1/1/1999
>             2/1/1998
>Any suggestions?

>Chris

Have a look at Sorting ListView ListItems Using Callbacks on vbNet  
 http://www.mvps.org/vbnet/code/callback/lvsortcallback.htm

HTH,
Bryan
____________________________________________________________
New Vision Software            "When the going gets weird,"
Bryan Stafford                   "the weird turn pro."

Microsoft MVP-Visual Basic     Fear and Loathing in LasVegas



Sun, 21 Mar 2004 01:53:40 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. CDO Rendering Views - ignores sort order?

2. Sort order - Edit Filter Sort or Quick Sort

3. How to list dir in sorted order?

4. Ordering a List View again !!!

5. Ordering a List View

6. Determining Column Order of List View

7. Sorting numbers in Descending Order using ORDER BY

8. Sorting numbers in Descending Order using ORDER BY

9. slow list view sorting - help needed

10. Sorting the content of list view on clicking column headers

11. List view and sorting

12. List View Sort Question

 

 
Powered by phpBB® Forum Software