Title: Sorting Issue
Last modified: November 13, 2019

---

# Sorting Issue

 *  Resolved [cirruslab](https://wordpress.org/support/users/cirruslab/)
 * (@cirruslab)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/sorting-issue-9/)
 * So I have a hidden Column 2 to that has dates like: 11/08/2019.
 * and custom command:
    `"columnDefs": [ { "orderData": [ 1 ], "targets": [ 2 ] },{"
   visible": false, "targets": [ 1 ] } ]`
 * In the backend it is sorting them properly, but in public when I want to sort
   that column, it seems to be ignoring the year.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsorting-issue-9%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/sorting-issue-9/#post-12129442)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * Can you please try extending that to
 *     ```
       "columnDefs": [ { "orderData": [ 1 ], "targets": [ 2 ] }, { "visible": false, "type": "date", "targets": [ 1 ] } ]
       ```
   
 * If that doesn’t work, we might have to switch to a `YYYY-MM-DD` date format for
   the hidden column, as that can be sorted as text.
 * Regards,
    Tobias
 *  Thread Starter [cirruslab](https://wordpress.org/support/users/cirruslab/)
 * (@cirruslab)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/sorting-issue-9/#post-12132249)
 * Awesome, thanks.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/sorting-issue-9/#post-12133144)
 * Hi,
 * no problem, you are very welcome! 🙂 Good to hear that this helped!
 * Best wishes,
    Tobias
 * P.S.: In case you haven’t, please [rate TablePress](https://wordpress.org/support/plugin/tablepress/reviews/)
   here in the plugin directory. Thanks!

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

The topic ‘Sorting Issue’ 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/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/sorting-issue-9/#post-12133144)
 * Status: resolved