Hello,

I can't get ARI Data Tables to sort my table by date in the format dd.mm.YYYY

You can find the table here:
www.tobias-knaack.de/index.php/sport/training-2013

I'm talking about the table called "Laufen"

The line with the date of 13.02.2013 is supposed to be at the top.

I'm getting the data from a mysql database where the date field has the MySQL Type of "DATE". The format of the date is converted
in the SQL query field of ARI Date Tables with this query:


SELECT
DATE_FORMAT(Datum,'%d.%m.%Y'),
Uhrzeit,
Sportart,...


I think I tried everything to get the table working. I tried all sorting type's for the date field, but the results are in the wrong order. I received the best result when I set sorting type to "text". When I tried the others the table is mixed up even more.

my settings for the sorting:


I hope you can help me.

Thanks in advance
Tobias Knaack

Hello,

It is possible to sort data in d-m-Y format. For this set "Sorting type" parameter to "Short date" value.

Regards,
ARI Soft

Thanks for your fast answer,

I changed the sorting type to short date, but the order of the date's doesn't change.

Thanks
Tobias

Donwload and upgrade "ARI Data Tables" module. After this set "ARI Table Sorter -> Date format" parameter to "UK format".

Regards,
ARI Soft

Thank you for your great and fast work!

Now the sorting works the way I wanted it to do.
I never had a support for any software that was as great as yours.

But I still have one thing that could be done. It would be great if
you could insert a german date format witch uses the dot instead of
the dash as divider. That is the usual way german people write dates.
23.05.2013 for example. But this is not urgent.

Thanks for your support
Tobias

Thank you for your suggestion. We will take it into account.

Regards,
ARI Soft