{"id":18997275,"date":"2026-08-19T11:32:32","date_gmt":"2026-08-19T11:32:32","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sorting-german-dates\/"},"modified":"2026-08-19T11:32:32","modified_gmt":"2026-08-19T11:32:32","slug":"sorting-german-dates","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sorting-german-dates\/","title":{"rendered":"Sorting german dates"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hello Tobias,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I have similar issues with date columns on two of my pages. There is each a table with two columns with German dates and I don&#8217;t get both date columns sorted correctly:<br \/>https:\/\/vectraturbo.de\/fahrzeugregister\/<br \/>https:\/\/vectra16v.com\/i500register\/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I tried these two variants based on other customer questions 6 solutions for https:\/\/vectraturbo.de\/fahrzeugregister\/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">0) import the base data as .CSV<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1) active &#8220;Advanced sorting plugin 1.2&#8221; +<br \/>columnDefs: [ { type: &#8220;formatted-num&#8221;, targets: [ 1, 8 ] } ]<br \/>=&gt; both columns sorted not correctly date sorted<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2) page with additional configparameter &#8220;datatables_datetime=DD.MM.YYYY&#8221;<br \/>=&gt; partly sorted<br \/>-&gt; 2nd column &#8220;EZL&#8221; not correctly date sorted<br \/>=&gt; 9th column &#8220;last change&#8221; correctly DE date sorted<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So whats the correct way to get both columns sorted correctly?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thanks in advance,<br \/>Kai<\/p>\n","protected":false},"template":"","class_list":["post-18997275","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18997275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18997275\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18997275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}