I have a report that produces a grid, with a leading date column.
I need to be able to format the date as "dd/mm/yyyy" and still have the sorting functioning correctly in the grid.
right now what I am doing is
select 'dbr.colstyle', 1, 'd/m/y;';
which results in initial correct order (of the query itself) and when clicking the column header to sort by date it becomes ordered alphabetically instead of by date.
Please advise how to do the formatting so that it functions correctly