Topic: sort column datetime doesn't work properly

dab213 premium asked 2 years ago

sort column with date type values doesn't work as expected. i am using datetime format DD/MM/YYYY HH24:MI

is there a way to solve this?


31/08/2021 11:08
30/07/2021 08:08
20/08/2021 11:08

Dawid Wajszczuk staff commented 2 years ago

Hi. In which component do you have this problem? Can you recreate your issue in the snippet It will help a lot.

dab213 premium commented 2 years ago

datatables component see in datetime column, the order isn't correct

Dawid Wajszczuk staff answered 2 years ago


Use YYYY/MM/DD HH24:MI instead and everything works fine. Here is the snippet

Keep coding,

dab213 premium commented 2 years ago


combining with the format function, it's possible to show it any way

Please insert min. 20 characters.


Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.



Specification of the issue

  • ForumUser: Premium
  • Premium support: Yes
  • Technology: MDB Standard
  • MDB Version: MDB5 3.9.0
  • Device: PC
  • Browser: Chrome
  • OS: Linux
  • Provided sample code: No
  • Provided link: No