hide GMT time for date column in grid

[Nivas]

Hi Team,

I have grid and loading data from Data table as below.

 @Html.EJS().Grid("Grid").DataSource((DataTable)ViewBag.FFReport).AllowFiltering().AllowMultiSorting(true).PageSettings(page => page.PageSizes(new List<object>() { 5, 10,15,20,25,30 })).AllowTextWrap(true).AllowPaging(true).AllowExcelExport(true).AllowResizing(true).Height("400").AllowExcelExport().ToolbarClick("toolbarClick").Toolbar(new List<string>() { "ExcelExport" }).FilterSettings(filter => { filter.Type(Syncfusion.EJ2.Grids.FilterType.Excel); }).AllowGrouping(false).Render()

How to hide the GMT time stamp in date columns.

[Mohammed Farook J]

Hi Nivas, 

 

Thanks for contacting Syncfusion support. 

 

 

We have validated your requirement and we found from your code, you can generate the column based on the dataSource.  So if we using auto generated column, we need to set the format for the date Column. Please find the code example for your reference. 

 

Code example 

 

 

 

 

@Html.EJS().Grid("Grid").DataBound("dataBound").DataSource((DataTable)ViewBag.FFReport).AllowFiltering().AllowMultiSorting(true).PageSettings(page => page.PageSizes(new List<object>() { 5, 10, 15, 20, 25, 30 })).AllowTextWrap(true).AllowPaging(true).AllowExcelExport(true).AllowResizing(true).Height("400").AllowExcelExport().ToolbarClick("toolbarClick").Toolbar(new List<string>() { "ExcelExport" }).FilterSettings(filter => { filter.Type(Syncfusion.EJ2.Grids.FilterType.Excel); }).AllowGrouping(false).Render() 

 

<script> 

    function dataBound() { 

        for (var i = 0; i < this.columns.length; i++) { 

            if (this.columns[i].type == 'date' || this.columns[i].type == 'datetime') { 

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

            } 

 

        } 

        this.refreshColumns(); 

    } 

</script> 

 

 

 

Here we have applied the format for date column by using ‘format’ property in “load” event of Grid. 

 

 

This is not meet your requirement , could you please explain more details about your requirement. 

 

Regards, 

J Mohammed Farook 

[Nivas]

Great, its working. thanks. 

[Nivas]

hi grid get hang when i load 10 records...Horizontal and vertical bar not moving 

[Mohammed Farook J]

 Hi Nivas,  

 

Thanks for you update. 

We are happy to hear that the provided solution was helpful to achieve your requirement. 

 

Query : grid get hang when i load 10 records...Horizontal and vertical bar not moving 

Please find the demo for enable scrolling in Grid.  

Demo :  https://aspnetmvc.syncfusion.com/Grid/DefaultScrolling#/material 

By default scrolling can be appears and working when the Grid content is exceed than height / width.  Still if you have facing same issue could you please share the following details 

1. Share the full grid code example with your data.
2. Share which version of  EJ2 script and DLL version used in your application?
3. Share the sample if it possible .
4. Share the console window if have any script error thrown

 

 

Regards, 

J Mohammed Farook 

[Nivas]

refreshColumns(); 

Refresh the grid every time when there is movement in grid. so  grid moving to initial potion.

if i remove refresh from the script its working fine but the date format change not reflecting.

[Mohammed Farook J]

Hi Nivas, 

 

Sorry for inconvenience cause. 

 

We have validated the reported issue and we found the root cause of issue due to called “refreshColumn” method continuously. For avoid this issue we can check the Grid is initial load or not while load event . Please update following code in your application. 

 

 

  

 

 

@Html.EJS().Grid("Grid").Load("load").DataBound("dataBound").DataSource((DataTable)ViewBag.FFReport).AllowFiltering().AllowMultiSorting(true).PageSettings(page => page.PageSizes(new List<object>() { 5, 10, 15, 20, 25, 30 })).AllowTextWrap(true).AllowPaging(true).AllowExcelExport(true).AllowResizing(true).Height("400").AllowExcelExport().ToolbarClick("toolbarClick").Toolbar(new List<string>() { "ExcelExport" }).FilterSettings(filter => { filter.Type(Syncfusion.EJ2.Grids.FilterType.Excel); }).AllowGrouping(false).Render() 

 

<script> 

    var initialLoad = false; 

    function load() { 

        initialLoad = true; 

    } 

    function dataBound() { 

        if (initialLoad) { 

            initialLoad = false; 

            for (var i = 0; i < this.columns.length; i++) { 

                if (this.columns[i].type == 'date' || this.columns[i].type == 'datetime') { 

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

                } 

 

            } 

            this.refreshColumns(); 

        } 

    } 

</script> 

 

 

Regards, 

J Mohammed Farook 

[Nivas]

working fine, Thanks for the help....

[Mohammed Farook J]

Hi Nivas,  

Thanks for the update.   

 

We are happy to hear that your problem has been resolved. 

 

Regards, 

J Mohammed Farook