We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel-like filtering DateTime

Thread ID:





123792 Apr 21,2016 02:18 PM UTC Apr 25,2016 12:10 PM UTC JavaScript 5
Tags: ejGrid
Pawel Klimczyk
Asked On April 21, 2016 02:18 PM UTC

I have Grid with excel-like filter.
One of the column is DateTime type.
It is configured as following:
            { field: "CreateDate", format: "{0:yyyy/MM/dd HH:mm:ss}", type: "datetime", width: 140 },

I have 2 issues. Both of them related to datetime filter.

My questions are one the attached screenshots below



Jayaprakash Kamaraj [Syncfusion]
Replied On April 22, 2016 09:19 AM UTC

Hi Pawel,

Thanks for contacting Syncfusion support.

Query1: How can I set time here it is always reset to 00:00:00

We fixed the issue in the latest version ( and suggest you to upgrade to the latest version from the following link.


Query2: How can I remove this from excel- like filter

We have achieved your requirement using actionComplete event. This event triggers for every complete actions in Grid and we used JQuery hide method to remove the excel filter search container for all the columns in Grid. Please refer to the following code example, Help document and sample.

<script type="text/javascript">

        $(function () {


                // the datasource "window.gridData" is referred from jsondata.min.js

                dataSource: window.gridData,

                allowPaging: true,

                allowFiltering: true,

                enableHeaderHover: true,


                filterSettings: { filterType: "excel" },

                columns: [

                        { field: "OrderID", isPrimaryKey: true, headerText: "Order ID", textAlign: ej.TextAlign.Right, width: 75 },

                        { field: "CustomerID", headerText: "Customer ID", width: 120 },

                        { field: "EmployeeID", headerText: "Employee ID", textAlign: ej.TextAlign.Right, width: 130 },

                        { field: "Freight", headerText: "Freight", textAlign: ej.TextAlign.Right,format: "{0:C2}", width: 80 },

                                         {field:"OrderDate",headerText:"OrderDate", format: "{0:yyyy/MM/dd HH:mm:ss}", type: "datetime", width: 140},

                        { field: "ShipCity", headerText: "Ship City", width: 90 },

                        { field: "Verified", headerText: "Verified", width: 90 }



            $("#filtermenu").ejDropDownList({ "change": "selectChange", width: "120px", selectedItemIndex: 0 })



        function selectChange(args) {                              

                $("#Grid").ejGrid("option", { "filterSettings": { "filterType": this.getSelectedValue() } });           


              function actioncomplete(args){




Help document: http://help.syncfusion.com/js/api/ejgrid#events:actioncomplete

Sample: http://jsplayground.syncfusion.com/xxyx0zhv


Jayaprakash K.

Pawel Klimczyk
Replied On April 22, 2016 09:22 AM UTC

Thank you Jayaprakash. I will give a try today :)

Pawel Klimczyk
Replied On April 22, 2016 01:50 PM UTC

Query 1 does not work

Pawel Klimczyk
Replied On April 25, 2016 11:03 AM UTC

Query 1 does not work

Any updates on this issue?

Jayaprakash Kamaraj [Syncfusion]
Replied On April 25, 2016 12:10 PM UTC

Hi Pawel, 
We have logged the requirement as an issue and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.  
Jayaprakash K. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon