Title: Column not sorting correctly
Last modified: September 12, 2024

---

# Column not sorting correctly

 *  Resolved [Wendy E Goldstein](https://wordpress.org/support/users/weg7/)
 * (@weg7)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcolumn-not-sorting-correctly%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/column-not-sorting-correctly/#post-18011416)
 * 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:
 *     ```wp-block-code
       "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)

The topic ‘Column not sorting correctly’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [1 year, 9 months ago](https://wordpress.org/support/topic/column-not-sorting-correctly/#post-18011416)
 * Status: resolved