how to sort date

 
1
0
-1

My datalist cannot sorting the date properly from the latest date.. 

How can I change the date format from string to date?

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      This is a database solution and out of the scope of Joget:

      Use a database utility such as SQLyog Community (for MySQL DB) and SQL update query with  the SUBSTRING() function to swap positions of the dd or MM or yyyy in your existing DB table.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Store your dates as "yyyy-MM-dd" and the date sorting in datalist will now work correctly (year first, month, and day, all in numeric values, for example, "2020-12-31").

        1. Nadh

          If I have already entered all the data in the system, do I need to re-enter it again?

        CommentAdd your comment...