Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
100
UltraWinGrid Sorting Column containing Oracle Date Format
posted

I'm new to the Infragistics package, and have inherited an application to support full of Infragistics.  I got a call saying that the grid column sort was not working.  Then someone noticed that when data is in the grid over a multitude of years, and it is sorted, all of the 1's are grouped together (like Jan 1, 2007, Jan 1, 2008, Feb 1, 2004....) and all of the 2's and all of the 3's.....anyway, this is data from an Oracle table, and since Oracle stores dates like '01-JAN-2007', I'm guessing that's why it is getting sorted in DAY order.  I need it sorted in regular date order.  It's taken me a while to even figure out where the "sort on" feature is (where I found it was in the Designer, under Feature Picker, under Header Click Sort Action, Single Column Sorting is checked).  Can anyone help?