Codejock Developer Community : Sorting by Date, Please HELP!!! http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 28 Apr 2026 11:55:21 +0000 Tue, 17 Jun 2008 13:16:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=11060 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sorting by Date, Please HELP!!! : thank you all, the CDate did...]]> http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36871&title=sorting-by-date-please-help#36871 Author: cmm2006
Subject: 11060
Posted: 17 June 2008 at 1:16pm

thank you all,
the CDate did the job.
]]> Tue, 17 Jun 2008 13:16:23 +0000 http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36871&title=sorting-by-date-please-help#36871 <![CDATA[Sorting by Date, Please HELP!!! : Also works if you initially pass...]]> http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36832&title=sorting-by-date-please-help#36832 Author: Stilki
Subject: 11060
Posted: 17 June 2008 at 12:54am

Also works if you initially pass in a date variable when calling AddItem.
Obviously the reportcontrol determines the data type when calling AddItem.
 
Set Item = Record.AddItem(CDate("15/7/08"))
]]> Tue, 17 Jun 2008 00:54:07 +0000 http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36832&title=sorting-by-date-please-help#36832 <![CDATA[Sorting by Date, Please HELP!!! : From my testing this workaround...]]> http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36816&title=sorting-by-date-please-help#36816 Author: Stilki
Subject: 11060
Posted: 16 June 2008 at 11:18pm

From my testing this workaround seems to work.
 
A date/time value can be represented by a numerical number. I use this number and assign it to the Item.Value property.
 
I then format the date/time value to my needs and assign it to the Item.Caption property.
 
The sorting then works fine.
 
eg. (In Visual Basic)
 
Item.Value = CDbl(ADateVariableWithAValue)
Item.Caption = Format$(ADateVariableWithAValue, "dd/mm/yy HH:MM AMPM")
]]> Mon, 16 Jun 2008 23:18:44 +0000 http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36816&title=sorting-by-date-please-help#36816 <![CDATA[Sorting by Date, Please HELP!!! : My application works with multiple...]]> http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36812&title=sorting-by-date-please-help#36812 Author: Smucker
Subject: 11060
Posted: 16 June 2008 at 9:52pm

My application works with multiple databases (and has to work across multiple time zones). Some databases don't have a built-in date format. So I store my database dates in ISO 8601 format as UTC (YYYY-MM-DDThh:mm:ss.ssssZ), which collates properly; then convert to local time and user's selected regional settings for display.

I don't know enough about the CJ COM controls (I use MFC) to know how difficult this would be, but there should at least be a callback for item comparison during sorting, wherein you could parse the dates and sort properly by YYYYMMDD.


http://en.wikipedia.org/wiki/ISO_8601]]> Mon, 16 Jun 2008 21:52:30 +0000 http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36812&title=sorting-by-date-please-help#36812 <![CDATA[Sorting by Date, Please HELP!!! : I have records in my database...]]> http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36801&title=sorting-by-date-please-help#36801 Author: cmm2006
Subject: 11060
Posted: 16 June 2008 at 3:47pm

I have records in my database that includes the OrderDate, but when I sort the reportcontrol by date, well it's not sorting properly. For instance:
if the OrderDate are as followed: 6/1/08, 6/2/08, 6/3/08, 6/11/08,6/12/08. The correct way the report suppose to be displayed the list is:
6/1/08
6/2/08
6/3/08
6/11/08
6/12/08
but instead, it shows the following:
6/1/08
6/11/08
6/12/08
6/2/08
6/3/08
any help!!!!
]]> Mon, 16 Jun 2008 15:47:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=11060&PID=36801&title=sorting-by-date-please-help#36801