Format data dd/mm/yyyy in a jquery Datatable.net

Question

How I format that date 2016-10-23T20:30:01.017 in one Datatable.net in the Brazilian format dd/mm/yyyy ?

Controller:

This relevant snippet of the code is where I populate the object that is in the ok format: dd/mm/yyyyyy hh:mm:ss:

List<Cliente> lTotalClienteAux = _IRepositorio.ListarCliente().ToList();

                List<Cliente> lTotalCliente = new List<Cliente>();
                foreach (var item in lTotalClienteAux)
                {
                    Cliente oCliente = new Cliente();
                    oCliente.ClienteID = item.ClienteID;
                    oCliente.DataCadastro = item.DataCadastro;                       
                    lTotalCliente.Add(oCliente);
                }

View When you click here in the View the format changes to: 2016-10-24T20:35:13.617

{
      "mRender": function (data, type, full) {
      var dt = full['DataCadastro'];
      return '<td>' + dt + '</td>';
     }
},

web config. On the web.config I have this tag indicating the culture:

<system.web>
    <globalization uiCulture="pt-BR" culture="pt-BR" enableClientBasedCulture="true" />

Answer 1

You can do it that way.

var data = new Date("2016-10-23T20:30:01.017");
var dia = data.getDate();
var mes = data.getMonth();
var ano = data.getFullYear();

document.write(dia + '/' + mes + '/' + ano);

Return

23/10/2016

Answer 2

Serialize the data to Datatable.net already in the correct format instead of using javascript to format the date. Deliver the data already ready.

In this line: oCliente.DataCadastro = item.DataCadastro;

You must do: oCliente.DataCadastro = item.DataCadastro.ToShortDateString();

The Dataregistration property of the Client class must be a string. If Client was a domain object, you must create a view model for your screen, in this case, Clienteviewmodel and in this view model, Datacadastro will be a string.