Datetime value not showing in jQuery data table

Question

I am trying to display some data in a datatable but Datetime in this case RegisterDate value not showing properly in jQuery data table. My Project is Asp.Net MVC. It shows as /Date(1542939575073)/ I do not know how to format my datetime in the jquery datatable function. Please help. Here is my code in my Index View ...

$(document).ready(function () {


            $("#myTable").DataTable({

                "processing": true,  
                "serverSide": true,  
                "filter": false,  
                "orderMulti": false,  
                "ajax": {
                    "url": "/Home/LoadEmployees",
                    "type": "POST",
                    "datatype": "json" 
                },
                "columns": [ 
                    { "data": "IdCardNr", "name": "IdCardNr", "autoWidth": true }, 
                    { "data": "RegisterDate","name": "RegisterDate", "autoWidth": true },
                    { "data": "PhonerNr", "name": "PhonreNr", "autoWidth": true },

                ] 
            });

        });

I know I must have kind of render some where inside but I do not know how to create it and where exactly to put it even if it should be right after "data" : "RegisterDate"

Possible duplicate of Datetime value not showing properly in jQuery data table — Bosco
– Bosco, Commented Aug 12, 2019 at 22:03

Abraham Russom · Accepted Answer · 2019-08-12 21:48:22Z

0

Put this code after "data": RegidterDate

 "render": function (mydata) {
                                var date = new Date(parseInt(mydata.substr(6)));
                                var month = date.getMonth() + 1;
                                return date.getDate() + "/" + month + "/" + date.getFullYear();

answered Aug 12, 2019 at 21:48

Abraham Russom

122 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Datetime value not showing in jQuery data table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related