Topic: sort column datetime doesn't work properly
                  
                  dab213
                  premium
                  asked 4 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 4 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 4 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 4 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 4 years ago
datatables component see in datetime column, the order isn't correct
https://mdbootstrap.com/snippets/standard/belgini/3387942