Codejock Developer Community : Date Sorting Problem

Codejock Developer Community : Date Sorting Problem http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 12:23:43 +0000 Mon, 19 Nov 2007 18:01:38 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=7983 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Date Sorting Problem : albrecht wrote:I have also...]]> http://forum.codejock.com/forum_posts.asp?TID=7983&PID=28639&title=date-sorting-problem#28639 Author: sserge
Subject: 7983
Posted: 19 November 2007 at 6:01pm

albrecht wrote:

I have also the Problem if I have a Size Column

with mixed SizeValues (xx KB, yy MB, ...) the sorting

is always alphabetic not numeric...

Well, when .Value property is available -- it sorts using it's Variant value (which may be numeric, date or anything else).

Otherwise it sorts by text strings.

It depends on how do you initialize items in your code.

--
WBR,
Serge
]]> Mon, 19 Nov 2007 18:01:38 +0000 http://forum.codejock.com/forum_posts.asp?TID=7983&PID=28639&title=date-sorting-problem#28639 <![CDATA[Date Sorting Problem : I have the sam problem, tried...]]> http://forum.codejock.com/forum_posts.asp?TID=7983&PID=28330&title=date-sorting-problem#28330 Author: albrecht
Subject: 7983
Posted: 09 November 2007 at 3:33pm

I have the sam problem,

tried to add a date value to an item

(as string and as date) but

sorting by date doesn't correct sort

could this be because of the windows

language setting?

I have also the Problem if I have a Size Column

with mixed SizeValues (xx KB, yy MB, ...) the sorting

is always alphabetic not numeric...

so I also hope for help :-)

regards

]]> Fri, 09 Nov 2007 15:33:25 +0000 http://forum.codejock.com/forum_posts.asp?TID=7983&PID=28330&title=date-sorting-problem#28330 <![CDATA[Date Sorting Problem : The control will sort date/time...]]> http://forum.codejock.com/forum_posts.asp?TID=7983&PID=26330&title=date-sorting-problem#26330 Author: sserge
Subject: 7983
Posted: 23 September 2007 at 5:12pm

The control will sort date/time columns automatically, but you have to properly set Value of corresponding items.

It looks for me that you sent a datetime value as a simple String, and it is sorted using String comparison rules.

--
WBR,
Serge
]]> Sun, 23 Sep 2007 17:12:40 +0000 http://forum.codejock.com/forum_posts.asp?TID=7983&PID=26330&title=date-sorting-problem#26330 <![CDATA[Date Sorting Problem : I am looking for a way to properly...]]> http://forum.codejock.com/forum_posts.asp?TID=7983&PID=25749&title=date-sorting-problem#25749 Author: rob@shuksan.com
Subject: 7983
Posted: 12 September 2007 at 11:39am

I am looking for a way to properly sort a report column by date. I need the column to sort in descending order where the most recent date is on top.

wndReportControl.SortOrder.Add wndReportControl.Columns(COLUMN_SENT)
wndReportControl.SortOrder(0).SortAscending = False
wndReportControl.Populate

The results come out as such:

9/3/2007 9:31 PM

9/11/2007 8:48 PM

9/1/2007 6:46 AM

Any help would be appreciated. Thx.

]]> Wed, 12 Sep 2007 11:39:47 +0000 http://forum.codejock.com/forum_posts.asp?TID=7983&PID=25749&title=date-sorting-problem#25749