Sort of date order wrong

  • Resolved ebramshehata

    (@ebramshehata)


    4 years, 2 months ago

    Hi i am trying to sort date column it sort wont like 31/7 then 30/7 then 1/8 then 2/8
    i want form low to high how can i solve this

Viewing 2 replies - 1 through 2 (of 2 total)

  • If your data in database or table is not uniformed, you can’t sort it. It must be correct date format, and you need to put, under column settings data type as date. Then it will work.

    Plugin Author wpDataTables

    (@wpdatatables)

    Hi there.

    Thank you for your help on this.

    That is correct, the type of the column needs to be “date” in order for it to sort normally. If the column is saved as “string”, it will be sorted in alphabetical order, and it won’t follow date sorting.

    Kind regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Sort of date order wrong’ is closed to new replies.

Tags