Visual Basic/VB, Sorting List View Control on date field??

Sorting List View Control on date field??

Author	Message
Rajesh Karker #1 / 6	Sorting List View Control on date field?? Hi to all I am having problem with sorting the fields in List view control. This issue is I am using the controls built in property .SortOrder = lvwAscending Since the sorting is done as text fields (That is by comparing the characters from left to right) when I have a filed with date data the sorting is not correct. So I want to have a fix to this problem. My date format has to be MM/DD/YYYY (so I am unable to change the date format to YYYY/MM/DD). Also I know I can programmatically do it by order by query (But this slows down the whole operation) Is there any other way I can solve this problem? Thanks to all inputs. Rajesh
Thu, 19 Aug 2004 00:07:21 GMT

#2 / 6	Sorting List View Control on date field??
Fri, 19 Jun 1992 00:00:00 GMT

Rajesh Karker #3 / 6	Sorting List View Control on date field?? Sorry Guys I think I found the answer I am yet to try this Knowledge base article Q170884 Thanks anyway! Rajesh Quote: > Hi to all > I am having problem with sorting the fields in List view control. This issue > is I am using the controls built in property .SortOrder = lvwAscending > Since the sorting is done as text fields (That is by comparing the > characters from left to right) when I have a filed with date data the > sorting is not correct. > So I want to have a fix to this problem. My date format has to be MM/DD/YYYY > (so I am unable to change the date format to YYYY/MM/DD). Also I know I can > programmatically do it by order by query (But this slows down the whole > operation) > Is there any other way I can solve this problem? > Thanks to all inputs. > Rajesh
Thu, 19 Aug 2004 00:48:12 GMT

Pat #4 / 6	Sorting List View Control on date field?? Just remember, your indices will be off after such a sort. -- Pat <Send E-mail FLAMES to the group only!> <All other group related E-Mails are accepted.> Hanlon's Razor: "Never attribute to malice that which can be adequately explained by stupidity." :o) \| Sorry Guys I think I found the answer \| I am yet to try this Knowledge base article Q170884 \| Thanks anyway! \| \| Rajesh \| \| > Hi to all \| > I am having problem with sorting the fields in List view control. This \| issue \| > is I am using the controls built in property .SortOrder = lvwAscending \| > Since the sorting is done as text fields (That is by comparing the \| > characters from left to right) when I have a filed with date data the \| > sorting is not correct. \| > So I want to have a fix to this problem. My date format has to be \| MM/DD/YYYY \| > (so I am unable to change the date format to YYYY/MM/DD). Also I know I \| can \| > programmatically do it by order by query (But this slows down the whole \| > operation) \| > Is there any other way I can solve this problem? \| > Thanks to all inputs. \| > \| > Rajesh \| > \| > \| \|
Thu, 19 Aug 2004 13:39:54 GMT

#5 / 6	Sorting List View Control on date field??
Fri, 19 Jun 1992 00:00:00 GMT

Markus Weber Megali #6 / 6	Sorting List View Control on date field?? Check out www.mvps.org/vbnet, there you can find a example. Search for "Listview" On Sat, 2 Mar 2002 11:07:21 -0500, "Rajesh Karkera" Quote: >Hi to all >I am having problem with sorting the fields in List view control. This issue >is I am using the controls built in property .SortOrder = lvwAscending >Since the sorting is done as text fields (That is by comparing the >characters from left to right) when I have a filed with date data the >sorting is not correct. >So I want to have a fix to this problem. My date format has to be MM/DD/YYYY >(so I am unable to change the date format to YYYY/MM/DD). Also I know I can >programmatically do it by order by query (But this slows down the whole >operation) >Is there any other way I can solve this problem? >Thanks to all inputs. >Rajesh
Fri, 20 Aug 2004 19:49:46 GMT

Page 1 of 1

[ 6 post ]