Incorrect sorting by date in 'DD.MM.YYYY' format

Dajzy

Description of problem:
When I am trying to sort by date in format 'DD.MM.YYYY' it does not sort corrently (Valid from, Valid to columns),
I checked forums and prepared some testing scenarious, but don't know why it isn't sorting as it should. Any ideas?
Link to test case:
https://live.datatables.net/dajzy/3/

kthorngren

Don't set the columns.type, ie, type: "date" for those columns nor run the render function you defined. Let type detection determine the type to match the DataTable.datetime('DD.MM.YYYY'); definition. Updated test case:
https://live.datatables.net/wutexudo/1/edit

The reason type detection didn't work is because type: "date" is configured.

Kevin