Dear ARI-soft,

How to make data table correctly sortable?
Dates in Mysql are stored in "yyyy-mm-dd" format.
In site data table I want to present dates in "%d-%m-%y" format. But sorting by pushing the table header results not in date sorting but in string sorting.

What to do? Could you help me?

The SQL query in ARI Datables module is:

SELECT Date_format(`Datum`,'%d-%m-%y') as Datum2,`Repetitie/Concert`,`Neue Bach Ausgabe`,`Moeilijke stukken`,`Tractant`,`Locatie` FROM `Jaarkalender RBE` ORDER BY `Datum` ASC

Regards,

Ben Hillen