Wrong value for date columns

[Halber Albarracin]

Hi, I have an issue with date columns, the first page load show undefined/undefined/undefined when user uses F5 show the data fine,,, 

I am using EJ2 with MVC .Net Core 2.2 

<div class="control-section">

    <ejs-grid id="FlatGridOrders" allowpaging="true" allowfiltering="true" allowsorting="true" locale="es-ES" datasource="@Model.ToList()">

        <e-grid-filtersettings type="Menu"></e-grid-filtersettings>

        <e-grid-columns>

            <e-grid-column field="Id" headertext="Id" visible="false" isprimarykey="true"></e-grid-column>

            <e-grid-column field="ProjectName" headertext="Proyecto" width="300" textAlign="Left"></e-grid-column>

            <e-grid-column field="ProjectPhaseName" headertext="Etapa" width="100" textAlign="Center"></e-grid-column>

            <e-grid-column field="ProjectBlockName" headertext="Manzana" width="100" textAlign="Center"></e-grid-column>

            <e-grid-column field="ProjectUnit1Identification" headertext="Lote" width="100" textAlign="Center"></e-grid-column>

            <e-grid-column field="OrderTypeName" headertext="Tipo" width="100" textAlign="Left"></e-grid-column>

            <e-grid-column field="OrderTransactionTypeName" headertext="Negociación" width="150" textAlign="Left"></e-grid-column>

            <e-grid-column field="OrderStatusName" headerText="Estado" template="#OrderStatusNameTemplate" width="100" textAlign="Left"></e-grid-column>

            <e-grid-column field="LastUpdateDateLocal" headertext="Fecha Actualización" customFormat="@(new { type ="date", format="dd/MM/yyyy" })" type="date"   ></e-grid-column>

        </e-grid-columns>

    </ejs-grid>

</div>

<script type="text/x-jsrender" id="OrderStatusNameTemplate">

    <div id="status" class="statustemp status${OrderStatusName}">

        <span class="status${OrderStatusName}">${OrderStatusName}</span>

    </div>

</script>

Attachment: Captura_de_pantalla_20210525_214250_97f9e92c.zip

[Sujith Kumar Rajkumar]

Hi Halber, 

 

Greetings from Syncfusion supposrt. 

 

We checked the reported problem from our end but unfortunately were unable to reproduce it as the date column was displayed properly. You can check the below sample for reference, 

 

Sample: https://www.syncfusion.com/downloads/support/forum/165796/ze/GridWithDateColumn-179534046 

 

The date column values present in the Grid’s data source need to be in Date object format as the date column operations(like, filtering, sorting, etc.) are done on the basis of date objects in the source-level. This is the Grid’s default behavior. So, if the date value is provided as string then please provide the date values in Date object format and check if the problem is resolved. 

 

If problem still persists, then please share us the following information to validate further on this, 

 

• Sample date column value bound in the Grid.
• Syncfusion package version used.
• Are any console errors thrown?
• If possible share us a simple sample to replicate the problem or try reproducing it in the above provided sample.

 

Regards, 

Sujith R