sorting date column in flex grid

hi,
When i use the sort property of the MS Flex grid (or MS hierarichal Flex grid) , the date columns are not sorted properly. How do i sort them ?
Is it possible using the "COMPARE" event of the Flex Grid. If yes ,what will be the code in the compare event.?

Hi
The easiest way to do this is to create an extra hidden column with the dates formatted as yyyymmdd. A sort on this column will produce the correct order.
Regards
Stuart