Big problem for big results

redsanso

Hello DT!
I have a big problem. I need all my dates in UK format. The fact is that I can't use aoColumns since I am also using a ColVis button, and the table is being loaded from some joins, so that there will not be fixed indexes for the dates column.
Is there something to do on oSettings?

I also need something that allows my editing functions to update values correctly within the mysql query, so that the displayed data is
dd-mm-yyyy, while the value in the sql query goes yyyy-mm-dd (otherwise it wouldn't update, since mysql only allows this format).
Thanks in advance.

I tried to post this in General also, but no one is answering.

allan

Sounds like you want to use the UK date sorting plug-in with a type detection function to match:

http://datatables.net/plug-ins/sorting#date_uk
http://datatables.net/plug-ins/type-detection#uk_date

For editing - what editor are you using? With Editor you would use the setFormatter function.

Allan