Hello,
In the RadGrid, we're currently using grouping on a date field. This data is being sorted in a format that's incorrect when related to dates though. The formatting is formatting the date as a string. For instance, if the data is sorted in ascending order, the data is grouped in the RadGrid as:
1/11/2009
1/23/2009
1/7/2009
1/9/2009
I assume this is because the field is being compared as a string; is there a way to specify that the field is a date and to sort that way, or another way to handle this?
In the RadGrid, we're currently using grouping on a date field. This data is being sorted in a format that's incorrect when related to dates though. The formatting is formatting the date as a string. For instance, if the data is sorted in ascending order, the data is grouped in the RadGrid as:
1/11/2009
1/23/2009
1/7/2009
1/9/2009
I assume this is because the field is being compared as a string; is there a way to specify that the field is a date and to sort that way, or another way to handle this?