Formatting a shortDate/Time in the grid.

[John Stemper]

In the column definition of the grid I am able to format a date as follows

col.Field("CreateDate").Format("yMd").Add();

but I need to format the date/time as month/day/year hour:minutes.

I've tried some of the standard formats that I am aware of but have not been able to get any of them to work.

[Seeni Sakthi Kumar Seeni Raj]

Hi John, 

Greetings from the Syncfusion support, 

We have validated query and we suggest you to use custom format to achieve your requirement. In the above sample, we have applied OrderDate column format as “MM/dd/yyyy”. Please refer the below code example and help documentation link for more information about custom date formatting. 

@Html.EJS().Grid("Grid").DataSource((IEnumerable<object>)ViewBag.datasource).Load("onLoad").Columns(col => 

{ 

    col.Field("OrderID").HeaderText("Order ID").Width("120").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add(); 

    col.Field("EmployeeID").HeaderText("EmployeeID").Width("120").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add(); 

    col.Field("CustomerID").HeaderText("CustomerName").Width("120").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add(); 

    col.Field("OrderDate").HeaderText("Date").Width("120").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add(); 

 

}).AllowPaging().AllowSelection(true).SelectionSettings(select=>select.Type(Syncfusion.EJ2.Grids.SelectionType.Multiple)).RowSelected("rowSelected").Render() 

 

<script> 

 

    function onLoad(args) { 

        this.columns[3].format = { type: "date", format: "MM/dd/yyyy" }; 

    } 

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

                                          https://ej2.syncfusion.com/aspnetmvc/documentation/common/internationalization/?no-cache=1#manipulating-datetime 

Regards, 

Seeni Sakthi Kumar S