Title: DE Date table filter Last modified: November 21, 2018 --- # DE Date table filter * Resolved [Florian](https://wordpress.org/support/users/pictibe/) * (@pictibe) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/) * Hi Tobias, * i read this topics but it doesnt work. Is it deprecated? [https://wordpress.org/support/topic/display-by-date/](https://wordpress.org/support/topic/display-by-date/) * I use this shortcode: * `[table id=1 datatables_locale="de_DE" responsive=flip responsive_breakpoint= tablet datatables_columnfilter=true datatables_fixedheader=top datatables_columnfilterwidgets =true datatables_columnfilterwidgets_exclude_columns=1,2,3,5,8,9 filter_date= future filter_date_columns=2 row_order=sort row_order_sort_column=B row_order_sort_direction =ASC /]` * and * `"columnDefs": [ { "type": "date-de", "targets": [ 2 ] } ], "order": [[ 2, 'asc']]` * and this small shortcode wont work too: * `[table id=1 filter_date=future filter_date_columns=2 /]` * I find the documentation but i cant get it work: [https://datatables.net/plug-ins/sorting/](https://datatables.net/plug-ins/sorting/) * This plugins are activated: * TablePress Extension: DataTables Column Filter * TablePress Extension: DataTables ColumnFilterWidgets * TablePress Extension: DataTables FixedHeader * TablePress Extension: DataTables Sorting plugins * TablePress Extension: Responsive Tables * TablePress Extension: Row Filtering * TablePress Extension: Row Filtering based on date * TablePress Extension: Table Row Order * The date have the normal German date format: 17.11.2018 * Any solution? Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903436) * Hi, * thanks for your post, and sorry for the trouble. * The Row Filter by Date Extension does only support the `mm/dd/yyyy` format. * (In addition, but a separate issue, `date-de` does not exist in your “Custom Command”, only `date-eu`.) * Regards, Tobias * Thread Starter [Florian](https://wordpress.org/support/users/pictibe/) * (@pictibe) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903452) * Wow, thanks for the fast reply. And how can we filter by German date? Is it possible with commands to adapt from / to .? * The extra column with /-date is not a user friendly solution. - This reply was modified 7 years, 6 months ago by [Florian](https://wordpress.org/support/users/pictibe/). * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903499) * Hi, * no, sorry, that’s not directly possible, due to the used date comparison functions. Your best chance is to add an extra column with the `mm/dd/yyyy` date format to your table, and use that for the filtering. You could then hide that column from the visitor on the “Edit” screen or using CSS code. * Regards, Tobias * Thread Starter [Florian](https://wordpress.org/support/users/pictibe/) * (@pictibe) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903534) * if i change the date without extra row and set / between numbers, the rows arent displayed. I can’t understand what happened. * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903585) * Hi, * I’m not sure what you mean here. Do you have an example? * Also, I can only recommend to do this step by step. The large first Shortcode that you posted will definitely lead to problems and it will not even work like this. * Regards, Tobias * Thread Starter [Florian](https://wordpress.org/support/users/pictibe/) * (@pictibe) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903812) * If i change the date from 22.11.2018 to 22/11/2018, then the row goes away in frontend. I test the large and the small shortcode on one site to compare the solutions. * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903932) * Hi, * `22/11/2018` is still the wrong format, it’s `dd/mm/yyyy`. You need to change it to `mm/dd/yyyy`, which would be `11/22/2018` in this example. * Regards, Tobias * Thread Starter [Florian](https://wordpress.org/support/users/pictibe/) * (@pictibe) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10903982) * Ok thats no way. Is no German date possible? It couldn’t be so complicated!?! * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10904876) * Hi, * no, sorry, there is no direct way, as the internal PHP sorting functions don’t directly support this. Your best chance is to use a second (hidden) column with the other format. * Regards, Tobias * Thread Starter [Florian](https://wordpress.org/support/users/pictibe/) * (@pictibe) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10909735) * Can i book your for a fix? Please write me an email if possible: info at pictibe de * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10909974) * Hi, * unfortunately, I’ll have to disappoint you here. As I’m not a professional web developer, I simply don’t have enough time and ressources to offer such services. * Regards, Tobias Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘DE Date table filter’ 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/) ## Tags * [date](https://wordpress.org/support/topic-tag/date/) * [date format](https://wordpress.org/support/topic-tag/date-format/) * [filter](https://wordpress.org/support/topic-tag/filter/) * [sorting](https://wordpress.org/support/topic-tag/sorting/) * 11 replies * 2 participants * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * Last activity: [7 years, 6 months ago](https://wordpress.org/support/topic/de-date-table-filter/#post-10909974) * Status: resolved