Member Avatar for newbie14

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.

  • 2 Contributors
  • 1 Reply
  • 94 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Momerath
Member Avatar for Momerath

If you want to sort dates you need to generate them as year-month-day, not day-month-year, or sort them in the select statement from the database, not after you get them.

Edited by Momerath because: n/a
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.