Title: Date Sequence in column Last modified: November 13, 2016 --- # Date Sequence in column * Resolved [gothriveblog](https://wordpress.org/support/users/gothriveblog/) * (@gothriveblog) * [9 years, 7 months ago](https://wordpress.org/support/topic/date-sequence-in-column/) * Please forgive this basic question but I looked throughout the support but could not find an answer. I have a table with dates in first column. I imported the source after making it a CSV file. If I do not do anything else it sorts the column numerically not in date sequence. I added the Datatables sorting plugin hoping that would work but I cannot find documentation on how to format the commands. I found this: “aoColumnDefs”: [ { “sType”: “date-eu”, “aTargets”: [ 0 ] } ] which sorts European dates but this is not what I need. I need American dates. The site is here: [http://godesanatools.com/conferencecalls/](http://godesanatools.com/conferencecalls/) I would appreciate your help very much. Viewing 13 replies - 1 through 13 (of 13 total) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [9 years, 7 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8431009) * Hi, * thanks for your question, and sorry for the trouble. * You should not need that Extension here, so that I suggest to remove it again. Instead, please try this “Custom Command”: `"columnDefs": [ { "type": "date"," targets": [ 0 ] } ]` * Regards, Tobias * Thread Starter [gothriveblog](https://wordpress.org/support/users/gothriveblog/) * (@gothriveblog) * [9 years, 7 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8431841) * Thank you, that was what i needed. I could not find the solution you gave me in the documentation. Is it in there and did I just miss it? * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [9 years, 7 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8432468) * Hi, * Good to hear that this helped! This is not in the TablePress documentation but in the DataTables documentation at [https://www.datatables.net/](https://www.datatables.net/) * Usually, this is not necessary as DataTables can auto-detect formats, but for some reason that failed here, which is why the “Custom Command” is necessary. * Regards, Tobias * [Thorsten Schraut](https://wordpress.org/support/users/hyperbrand/) * (@hyperbrand) * [9 years, 7 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8433863) * Hi Tobias, * I have a similar problem with german date formats. We tried this line of command“ columnDefs”: [ { “type”: “formatted-num”, “targets”: [ 1 ] } ] but it doesn’t work. Any idea? * [https://albionacademy.de/tabellen-test/](https://albionacademy.de/tabellen-test/) * Thanks in advance. * Best, Thorsten * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [9 years, 7 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8433921) * Hi Thorsten, * for you, it should actually be sufficient to force DataTables to use German as its language. This will work by setting the site’s language to German, or by adding a parameter to the Shortcode: `[table id=23 datatables_locale="de_DE"/]` You should then not need that “Custom Command”. * Regards, Tobias * [Thorsten Schraut](https://wordpress.org/support/users/hyperbrand/) * (@hyperbrand) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8443099) * Hi Tobi, * thank you for your help. The locale did the trick :). * Best, Thorsten * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8443237) * 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/#new-post) here in the plugin directory. Thanks! * [Thorsten Schraut](https://wordpress.org/support/users/hyperbrand/) * (@hyperbrand) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8497934) * Hi Tobi, * it’s me again. My client set up a new table with this shortcode [table id=testtable datatables_locale=”de_DE” /] but the date is not sorting correctly. Any ideas? * [https://albionacademy.de/testtable/](https://albionacademy.de/testtable/) * Best, Thorsten * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8497969) * Hi Thorsten, * that’s strange… Please try forcing the date format by adding this to the “Custom Commands” (“Eigene Befehle”) text field on the table’s “Edit” screen: `"columnDefs":[{" type": "date", "targets": [ 2 ] } ]` * Regards, Tobias * [Thorsten Schraut](https://wordpress.org/support/users/hyperbrand/) * (@hyperbrand) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8542521) * Hi Tobi, * that sutom command didn’t work. Still confused why that happens? Sorry for not getting back earlier. Missed the email notification. * Best, Thorsten * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8543794) * Hi Thorsten, * ok, you might then need the TablePress Extension from [https://tablepress.org/extensions/datatables-sorting-plugins/](https://tablepress.org/extensions/datatables-sorting-plugins/) * After installing that, please also modify the “Custom Command” to `"columnDefs":[{" type": "date-eu", "targets": [ 2 ] } ]` Regards, Tobias * [Thorsten Schraut](https://wordpress.org/support/users/hyperbrand/) * (@hyperbrand) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8548150) * Hi Tobi, * thanks for your quick response. It does work now. * Thanks, Thorsten * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8548287) * Hi, * great! Thanks for the confirmation! * Best wishes, Tobias Viewing 13 replies - 1 through 13 (of 13 total) The topic ‘Date Sequence in column’ 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/) * 13 replies * 3 participants * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * Last activity: [9 years, 6 months ago](https://wordpress.org/support/topic/date-sequence-in-column/#post-8548287) * Status: resolved