Title: Sorting Dates
Last modified: December 1, 2017

---

# Sorting Dates

 *  Resolved [Gadasoft](https://wordpress.org/support/users/gadasoft/)
 * (@gadasoft)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/sorting-dates/)
 * Hello,
 * i have installed the sorting plugin, entered “columnDefs”: [ { “type”: “formatted-
   num”, “targets”: [ 5 ] } ] as custom command to try and force the date format,
   yet it still refuses to sort. E.g. 01.12.2017 goes before 25.11.2017.
 * Any idea what i am doing wrong ?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsorting-dates%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/sorting-dates/#post-9740259)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * `formatted-num` is the wrong type. You want to use `date-eu`.
 * Regards,
    Tobias
 *  Thread Starter [Gadasoft](https://wordpress.org/support/users/gadasoft/)
 * (@gadasoft)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/sorting-dates/#post-9740301)
 * Is it possible that its conflicting with the Table Row Order plugin ? Im using
   the following code to sort by Column F ( the date column ). It seems to be sorting
   correctly when i press the column arrow, but not automaticaly as it should 🙁
 * row_order=sort row_order_sort_column=F row_order_sort_direction=DESC
 * Sorry to be a bother and thank you so much for your time !
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/sorting-dates/#post-9740345)
 * Hi,
 * indeed, the Table Row Order Extension works differently, it does not take these
   commands into account (it doesn’t use JavaScript).
    Instead, you could use the“
   Custom Command”:
 *     ```
       "columnDefs": [ { "type": "date-eu", "targets": [ 5 ] } ], "order": [[ 5, 'asc' ]]
       ```
   
 * Regards,
    Tobias
 *  Thread Starter [Gadasoft](https://wordpress.org/support/users/gadasoft/)
 * (@gadasoft)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/sorting-dates/#post-9740413)
 * That works perfectly, thank you so much for your time and have a great weekend.
   Will see to support your work !
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/sorting-dates/#post-9740465)
 * 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 5 replies - 1 through 5 (of 5 total)

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

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