I am trying to accomplish sorting using
ug_TestSeach.DisplayLayout.Bands(0).SortedColumns.Add(
"SORTME_COLUMN", True)
it seems to work fine all columns (tried bunch of them with different data types) but its not sorting correct for a datatype datatime column.
I am not sure if this is a bug. Please let me know what i need to do to get this to work
Thanks in advance
From a technical standpoint, what exactly do you mean by "not sorting correctly?" How is the DateTime column being sorted for you that's different from when you sort another column?
The values in the sort doesnt look right , i am trying to sort created_date descending so that i will have recently created row on the top of the grid.
It seems to work fine most part but sme of the order will be wrong
Just like below example
05/10/2009 -- this is correct
05/09/2009-- this is correct
04/10/2009 -- this needs to be 4th in the list
04/13/2009 -- this needs to be 3rd in the list
If i do a select query and order by date in desc i get the intended behaviour.
This most definitely doesn't look right. I'm trying to determine a pattern based on the order you've mentioned, and I don't yet see it.
Can you reproduce this in a sample that we could run and debug?