Date format

cala

Hi,

I have a date column in my table. Without any configuration, in the Editor the format is dd/mm/yyyy, but when the table is shown, it is mm/dd/yyyy.

How can I correct the visualization in the table?

Thank you!

btree

Hi,

you can use the "Set" formatter if you use php and editor.
https://editor.datatables.net/manual/php/formatters

If you only want to change the visual in the table you also can use the "render" function.
https://datatables.net/reference/option/columns.render

Cheers
Hannes

cala

Thanks Hannes!

For users that have same problem, I've used:

var table=$('#my_table').DataTable( {
    columns: [
        ...many columns...
        { 
            data: "my_date_column_name",
            render: function (data) {
                if(data === ""){
                    return '00-00-0000';
                }       
                from = data.split("-");
                f = from[2]+'-'+ from[1]+'-' + from[0];
                return f;
            }   
        }
    ]
})