Date Column Filter Problem

[Erdal Köklü]

Hi,

I am having trouble filtering the date column in the grid. Can you help with this? Below, I give the link of the process I exemplified on Stackblitz. 

I have also found that you have the same problem in your own documentation.

Example: https://stackblitz.com/edit/fudxwl-ahj8ga?file=index.js

Also Your documentations: https://ej2.syncfusion.com/javascript/documentation/grid/filtering/#custom-component-in-filter-menu 

[Rajapandi Ravi]

Hi Erdal, 

Greetings from syncfusion support 

We have analyzed your query and we could see that you like to filter the date column with date and time. We suggest you to parse the json data before applying to the Grid, through a method parseJson in DataUtil. Which parses the date string to date Objects. Please refer the below code example and sample for more information. 

 

var grid = new ej.grids.Grid({ 

  dataSource: DataUtil.parse.parseJson(JSON.stringify(scopedata)), 

  allowFiltering: true, 

  filterSettings: { enableCaseSensitivity: true, type: "Menu" }, 

  columns: [ 

    { 

      field: "OrderDate", 

      headerText: "Order Date", 

      width: 140, 

      format: { type: "dateTime", format: "dd/MM/yyyy hh:mm a" }, 

      textAlign: "Right" 

    } 

  ], 

  allowPaging: true, 

  pageSettings: { 

    pageCount: 8, 

    pageSizes: [25, 50, 100, 500, 1000, 5000], 

    pageSize: 25 

  } 

}); 

grid.appendTo("#Grid"); 

Sample: https://stackblitz.com/edit/fudxwl-r4ev1j?file=index.js 

Screenshot: 

 

Regards<
Rajapandi R