Topic: sort column datetime doesn't work properly

dab213 premium asked 3 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?

example:

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

Dawid Wajszczuk staff commented 3 years ago

Hi. In which component do you have this problem? Can you recreate your issue in the snippet https://mdbootstrap.com/snippets/? It will help a lot.


dab213 premium commented 3 years ago

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

https://mdbootstrap.com/snippets/standard/belgini/3387942


Dawid Wajszczuk staff answered 3 years ago


Hi,

Use YYYY/MM/DD HH24:MI instead and everything works fine. Here is the snippet https://mdbootstrap.com/snippets/standard/d-wajszczuk/3390477.

Keep coding,
Dawid


dab213 premium commented 3 years ago

thanks!

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



Please insert min. 20 characters.

FREE CONSULTATION

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

Status

Answered

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