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 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
FREE CONSULTATION
Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.
Answered
- 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
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