Codejock Developer Community : Sorting of Date-Columns http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:42:07 +0000 Thu, 02 Feb 2006 04:27:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=3581 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sorting of Date-Columns : When you add the date the report...]]> http://forum.codejock.com/forum_posts.asp?TID=3581&PID=10766&title=sorting-of-datecolumns#10766 Author: LeeHayton
Subject: 3581
Posted: 02 February 2006 at 4:27am

When you add the date the report does not know what type of field it is so you need to tell it by encapsulating it in the CDate() command.

             Set Item = Record.AddItem(CDate(RS!RegDate))

This works great for me!

The same goes for strings cstr(), integers cint(), etc. which orders number columns numerically as opposed to alphabetically.

]]> Thu, 02 Feb 2006 04:27:02 +0000 http://forum.codejock.com/forum_posts.asp?TID=3581&PID=10766&title=sorting-of-datecolumns#10766 <![CDATA[Sorting of Date-Columns : Hi, Look into Sub SetDateItem()...]]> http://forum.codejock.com/forum_posts.asp?TID=3581&PID=10760&title=sorting-of-datecolumns#10760 Author: sserge
Subject: 3581
Posted: 01 February 2006 at 4:37am

Hi,

Look into Sub SetDateItem() in the sample app. When you set item value with Date type, it will be automatically properly sorted.

--
WBR,
Serge]]> Wed, 01 Feb 2006 04:37:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=3581&PID=10760&title=sorting-of-datecolumns#10760 <![CDATA[Sorting of Date-Columns : How can I specify columns as &#034;date&#034;...]]> http://forum.codejock.com/forum_posts.asp?TID=3581&PID=10754&title=sorting-of-datecolumns#10754 Author: cbickel
Subject: 3581
Posted: 31 January 2006 at 4:22pm

How can I specify columns as "date" - columns to get them sorted properly ?]]> Tue, 31 Jan 2006 16:22:27 +0000 http://forum.codejock.com/forum_posts.asp?TID=3581&PID=10754&title=sorting-of-datecolumns#10754