Dear All,
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.
newbie14 0 Posting Pro
Momerath 1,327 Nearly a Senior Poster Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.