Topic: table sorting not working for date column

modadvisor free asked 2 years ago

date column sorting not working.

my date format is MM/DD/YYYY when i click on header it sorts with month only not considered day and years. please let me know how can i do it ?

                label: "From",
                field: "eff_date",
                datepicker: true,
                sorting : true                    

please guide me the modification required. Thanks

frankvdsm priority answered 2 years ago

First of all: make sure taht the date in your datasource table is in the format YYY-MM-DD.

Don't apply the format to your datatable but create a function like this:

public showTimestamp(n: string) {

let y = n.substr(0,4);

let m = n.substr(5,2);

let d = n.substr(8, 2);

return d + "/" + m + "/" + y; }

in your HTML us this function like this:

{{ showTimestamp(v.datum) }}

Your data is always shown in the right format and is also shown sorted correctly.

Regards, Frank

Mikołaj Smoleński staff commented 2 years ago

@modadvisor were @frankvdsm tips helpful?

Keep coding,  Mikołaj from MDB

modadvisor free commented 2 years ago

i am using mdb vue data table within data table how i can call your function ?

Mikołaj Smoleński staff commented 2 years ago

I guess @frankvdsm fix is applicable only in MDB5. In MDB4 datatable there is no other option than changing date format to YYYY/MM/DD.

Keep coding,  Mikołaj from MDB

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: Free
  • Premium support: No
  • Technology: MDB Vue
  • MDB Version: MDB4 6.7.2
  • Device: PC
  • Browser: chrome
  • OS: windows 10
  • Provided sample code: No
  • Provided link: No