Problem formatting date value in grid

Hi,

I have a grid:

@Html.EJS().Grid("grdBeneficiarios").DataSource(dataManager => { dataManager.Json(Model.ToArray()).InsertUrl("/Contrato/AgregarBeneficiario").RemoveUrl("/Contrato/EliminarBeneficiario").UpdateUrl("/Contrato/ActualizarBeneficiario").Adaptor("RemoteSaveAdaptor");}).ActionBegin("actionBegin").Columns(col =>
{
    col.Field("IdBeneficiario").IsPrimaryKey(true).IsIdentity(true).Visible(false).Add();
    col.Field("IdTiposIdentificacion").HeaderText("Tipo id").ForeignKeyField("IdTiposIdentificacion").ForeignKeyValue("Nombre").DataSource((List<TipoIdViewModel>)PersonaServices.GetTiposId()).Add();
    col.Field("NumeroId").HeaderText("Numero id").Add();
    col.Field("PrimerNombre").HeaderText("Primer nombre").Visible(false).Add();
    col.Field("SegundoNombre").HeaderText("Segundo nombre").Visible(false).Add();
    col.Field("PrimerApellido").HeaderText("Primer apellido").Visible(false).Add();
    col.Field("SegundoApellido").HeaderText("Segundo apellido").Visible(false).Add();
    col.Field("NombreCompleto").HeaderText("Nombre").Add();
    col.Field("TelefonoMovil").HeaderText("Celular").Add();
    col.Field("Email").HeaderText("Email").Add();
    col.Field("IdSede").HeaderText("Sede").ForeignKeyField("IdSede").ForeignKeyValue("Nombre").DataSource((List<SedeViewModel>)ContratoServices.GetSedes().FindAll(s => s.Habilitado)).Add();
    col.Field("WelcomeDay").HeaderText("Welcome day").Format("MM/dd/yyyy hh:mm").EditType("datetimepickeredit").Add();
    col.Field("Observaciones").HeaderText("Obs").Add();
    col.HeaderText("Enviar email").Width("160").Commands(comandos).Add();
    col.Field("IdContrato").Visible(false).Add();
}).Locale("es-CO").DataBound("dataBind").Load("load").EditSettings(edit => { edit.AllowAdding(true).AllowEditing(true).AllowDeleting(true).Mode(Syncfusion.EJ2.Grids.EditMode.Dialog); }).Toolbar(toolbarItems).Render()

But no data is displayed, except when I delete the .Format option for the "WelcomeDay" column. The problem is that the value showed is: 

is too long!.

Hi Juan, 

Thanks for contacting Syncfusion support. 

You need to format the date value as follows with your own format value. 

Please refer to the below documentation link. 

https://ej2.syncfusion.com/aspnetmvc/documentation/grid/columns/#date-formatting 

Regards, 

Madhu Sudhanan P 

Thanks so much. Now it is working but, now I have the same problem with the grid using Javascript.

My code is like the sample in documentation in https://ej2.syncfusion.com/javascript/documentation/grid/columns/#date-formatting :

With the format included, no rows are shown but, if I delete the format, all rows are shown

I don´t know what is wrong, I am writting in the same way as the sample in documentation.

Thanks for your help,

Kind regards,

Juan.

Hi Juan, 

Thanks for your Update. 

We have analyzed your query but we are unable to reproduce the reported issue at our end. So please provide the below information for us, it will help us provide a better solution as soon as possible, 

Sample: https://stackblitz.com/edit/hp1ghs-qdcnew?file=index.js  

Please get back to us for further assistance. 

 

Regards, 

Pavithra S. 

 

I am still facing this issue with javascript.

Thanks for your help, kind regards

Juan J.

Hi Juan, 

Thanks for the provided details. 

From your screenshot, we found that date column value is in JSON string format. But it is necessary to provide the JSON data to JsonAdaptor instead of this JSON string. So we suggest to parse this JSON string to JSON data before providing it to Grid. Please refer the following code snippet, 

Regards, 

Hariharan 

Kind regards,

Juan J.

Hi Juan, 

 

Thanks for your update.  

  

We are happy to hear that the provided solution helped you.   

  

Please contact us if you need any further assistance. As always, we will be happy to assist you.   

  

Regards, 

Hariharan