sorting flexgrid by date column

[robertlees]

I have a 5 column flexgrid. I want the user to click a column and get the grid sorted by that column. Works fine for non-date collumns. For date columns, I firstly loop through all rows changing them from dd/mm/yy to yy/mm/dd. But the sort doesn't do anything.

[Comatose]

:eek:

check this thread out: http://www.daniweb.com/techtalkforums/showthread.php?t=41491&highlight=datediff

[robertlees]

Thanks for your reply.

I looked at that link. Not sure it helped me a hell of a lot. If I have to do a bubble sort, then I can work that out. But why does the flexgrid sort work on non-dates. Does it use some other property other than my changed captions ?

[Comatose]

Ok, sorry about that..... I looked a little deeper into the situation, and it seems that it's a known flaw (sorting dates) with the flexgrid control.... here is a workaround: http://www.freevbcode.com/ShowCode.asp?ID=5703

Basically, you use a hidden column to sort the data, and then repopulate..... let me know how this turns out for you, or if you need more help with this.

[robertlees]

Excellent. Makes sense. Thanks for the update.