sorting or ordering by date not always working
521773Sep 28 2006 — edited Sep 30 2006Morning team,
I am trying to sort results in a report by transaction date but sometimes it doesn't work (as shown below)
I have tried ticking the Sort check box in Report Attributes for the transaction_date column.
I also tried an order by clause in the query.
The data is imported from a csv file. Most of the data is sorted correctly but about 5% is not.
I can live with it but it would be nice to fix it.
(Using Apex 2.1.0.00.39 and 1-15 row range select list pagination)
id_column transaction_date
192 27/09/2006
193 27/09/2006
194 27/09/2006
74 14/08/2006
75 14/08/2006
76 14/08/2006
thanks,
Brett