I am generating a report via crystal report. I am reading data from mysql db and one of the sample field I format is Cast(DATE_FORMAT(tblFranchiseTransfer.franchiseTransferFromDate, '%d-%m-%Y') As Char) as franchiseTransferFromDateOriginal. One problem I have few data which is ordered in this flow 04-01-2011,12-01-2011,13-01-2011,18-12-2010. I have ordered as ascending so by right the 18-12-2010 should be first. Any help please? I have made the data set field for the date as string.