Codejock Developer Community : Sorting Date http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 03:43:59 +0000 Fri, 18 Mar 2005 08:10:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=1984 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Sorting Date : Oleg, I understand the changes.... Item.Value...]]> http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5809&title=sorting-date#5809 Author: flauzer
Subject: 1984
Posted: 18 March 2005 at 8:10am

Oleg,

I understand the changes....

Item.Value = f.Value

and 'after' use the FORMAT method.....
Item.Format =.....


This work!!!Embarrassed]]> Fri, 18 Mar 2005 08:10:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5809&title=sorting-date#5809 <![CDATA[Sorting Date : The problem is DATETIME. This...]]> http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5807&title=sorting-date#5807 Author: flauzer
Subject: 1984
Posted: 18 March 2005 at 8:01am

The problem is DATETIME.

This is my function, the result is WRONG:::

ie:.... I obtain in Data column (decrescent):

23/10/2005 14.56
23/08/2005 14.53
14/05/2005 14.52
13/07/2005 14.53
06/03/2004 14.51
03/11/2005 14.56
03/06/2005 14:53




Public Function WrapRP(ByVal f As Field, ByRef Item As ReportRecordItem)
    '----------------------------------------------------
    'Wrap CodeJock grid
    '----------------------------------------------------
    Select Case f.Type
    
         &nbs p;       Case adDBTimeStamp, adDBDate
         &nbs p;          
         &nbs p;          If IsNull(f) Then
         &nbs p;              Item.Value = vbNullString
         &nbs p;           Else
         &nbs p;              Item.Value = Format(CStr(f.Value), "dd/mm/yyyy hh:mm")
         &nbs p;              Item.SortPriority = CLng(Format(CStr(f.Value), "yyyymmddhhmm"))
         &nbs p;           End If
         &nbs p;          
         &nbs p;      Case Else
         &nbs p;          
         &nbs p;          If IsNull(f) Then
         &nbs p;              Item.Value = vbNullString
         &nbs p;           Else
         &nbs p;              Item.Value = CStr(f)
         &nbs p;           End If
         &nbs p;
    End Select
   
   
End Function
 ]]> Fri, 18 Mar 2005 08:01:23 +0000 http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5807&title=sorting-date#5807 <![CDATA[Sorting Date : How you add this report item? Try...]]> http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5806&title=sorting-date#5806 Author: Oleg
Subject: 1984
Posted: 18 March 2005 at 7:27am

How you add this report item?

Try simply add it as date value.

]]> Fri, 18 Mar 2005 07:27:54 +0000 http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5806&title=sorting-date#5806 <![CDATA[Sorting Date : PS.... .....long limit is 2147483647 ...]]> http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5801&title=sorting-date#5801 Author: flauzer
Subject: 1984
Posted: 18 March 2005 at 7:11am

PS....
.....long limit is 2147483647

]]> Fri, 18 Mar 2005 07:11:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5801&title=sorting-date#5801 <![CDATA[Sorting Date : I&#039;d got &#034;overflow&#034;...]]> http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5800&title=sorting-date#5800 Author: flauzer
Subject: 1984
Posted: 18 March 2005 at 7:04am

I'd got "overflow" problem , to be honest some month ago....

I only want to know if someone uses correctly the datetime format without problems.

Thanks......



]]> Fri, 18 Mar 2005 07:04:06 +0000 http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5800&title=sorting-date#5800 <![CDATA[Sorting Date : flauzer wrote:Item.SortPriority...]]> http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5797&title=sorting-date#5797 Author: gshawn
Subject: 1984
Posted: 18 March 2005 at 5:35am

Originally posted by flauzer flauzer wrote:

Item.SortPriority = CLng(Format(CStr(f.Value), "yyyymmddhh")) works until HOURS and not MINUTE......

Is there any reason why you can't do

Item.SortPriority = CLng(Format(CStr(f.Value), "yyyymmddhhmmss"))

?

 

]]> Fri, 18 Mar 2005 05:35:01 +0000 http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5797&title=sorting-date#5797 <![CDATA[Sorting Date : sorry.....old problem on ReportControl...]]> http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5796&title=sorting-date#5796 Author: flauzer
Subject: 1984
Posted: 18 March 2005 at 4:12am

sorry.....old problem on ReportControl (9.6.0.1 version )

Is there a way,(trick,workaround,....)
that can sort a dateTIME column correctly.... (it has to work with at data and a TIME)????????


PS
Item.SortPriority = CLng(Format(CStr(f.Value), "yyyymmddhh")) works until HOURS
and not MINUTE......


Thanks
]]> Fri, 18 Mar 2005 04:12:22 +0000 http://forum.codejock.com/forum_posts.asp?TID=1984&PID=5796&title=sorting-date#5796