I have been trying to find a way to sort items in the grid other than Alphabetically.

Specifically Date Order and Numeric Order.

The closest thing I could find is the PropertySort Property but this only offers group, alphabetical and none as options.

I checked out the Report Control sample since that has a "Date Received" column hoping that I could just copy what was happening there. However it seems that the sample doesnt sort items correctly either. (date order that is) 

Is there a way to do this that Im not seeing?

If not can you please add it for the next release.

If there is then you might want to fix the sample application.

Thanks

Hi Maui

I've been tryin g to solve the same problem. I posted a possible solution in the General Discussion forum: https://forum.codejock.com/forum_posts.asp?TID=1097&PN=1#2851 - https://forum.codejock.com/forum_posts.asp?TID=1097& PN=1#2851

I use a similar solution for formatting and sorting numeric values.

Hope this helps for now...

Thanks.

I converted my date  and then added it like this and it sorted fine.

Item.Value = MyDateValue
Item.SortPriority = CSng(CDate(MyDateValue))

no worries, glad to help.

Do you think that it is necessary for the multiple conversions?

• Datetimes are stored as a number with the whole number representing the date and the decimal reresenting the time
• Once you've converted to a single, the property will then have to convert the value to a long anyways...

I now add the cell with the value I am going to be sorting on (this goes into the .value property) and then use .caption to format the display.

I think the reason I didnt do it this way before was because I just copied and pased code from the sample and that worked fine.