Sorting converted epoche dates

dg_datatables

Hi everyone,
the customer database provides "only" unix time seconds. I easily convert the unix time seconds to date with the render function:

                { data: "startdate>",
                    render: function (data, type, row) {
                        var dtst = "";
                        if (data > 0 && type === "display")
                        {
                            var mydate = new Date(data * 1000);
                            var myyear  = mydate.getFullYear();
                            var mymonth = mymonth.getMonth() +1;
                            var myday  = mydate.getDate();

                            if (mymonth< 10) { mymonth= "0" + mymonth; }
                            if (myday  < 10) { myday  = "0" + myday  ; }

                            dtst = myday  + "." + mymonth + "." + myyear  ;
                        }
                        return dtst;
                    }
                }

This works fine without using the moment.js
But i can't sort this column. Pressing on the sort buttons it has absoluty no effect.

Where am i wrong?

colin

Hi @dg_datatables ,

It's because you are always returning an empty string for the sort type - just return data as in this example here.

Cheers,

Colin

dg_datatables

Sorry - I'm blind!
I do not see a difference between your Code and mine. Your Code is working, but where is the difference?

colin

Ha, very subtle change - it's the first line in the render function:

var dtst = data;

dg_datatables

Oh yessssss
Thank's a lot for your help.