Column not sorting correctly

  • I want to sort by date in the tables. They seem to sort correctly by day/month but not by the year. I input the date as dd/mm/yyyy. Is this correct? Or do I need to do something else to get the column to sort by date.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi!

    Thanks for your post and sorry for the trouble!

    It looks like you are using the mm/dd/yyyy date format in your table’s third column, but the type detection is not picking that up. To get around that, please add this to the “Custom Commands” text field on the table’s “Edit” screen:

    "columnDefs": [ { "type": "date", "targets": [ 2 ] } ]

    (The 2 in the "targets" list refers to the third column, as counting the columns starts with 0 for the first column.)

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.