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

Filter On Date Column

Thread ID:





117850 Dec 26,2014 10:07 AM UTC Jan 5,2015 12:59 PM UTC ASP.NET Web Forms (Classic) 3
Tags: GridGroupingControl
Chong Yee Mei
Asked On December 26, 2014 10:07 AM UTC


My ggc column is bind to a datatable that have the default date format like  "12/6/2011 1:01:21 PM", however when I filter the column using the exact date, "12/6/2011 1:01:21 PM", I didn't get the intended result, later on I found out that I need to filter using the date format from sql server 2008 r2 which looks like "2011-12-06 13:01:21.733" to get the result I want.

Kindly advice what is the possible cause of this.

Thank you,
Yee Mei

Shanmugaraja K [Syncfusion]
Replied On December 31, 2014 12:57 PM UTC

Hi Chong,


Thanks for using Syncfusion products.


Before we start to providing the solution, we would like to hear more details to reproduce the issue so could you please share the below information?,


1.       Whether you are set any system culture?

2.       Do you have set any format for the date column in Grid.

3.       Which type of filter you are using in your project (Combo filter or Text filter)?

4.       Which Grid you are using in your project (Ajax Grid or Normal Grid)



Shanmugaraja K

Chong Yee Mei
Replied On January 2, 2015 07:29 AM UTC

Hi Shanmugaraja ,


1. No.

2. No.

3. I tried on both filter, but they behave in the same manner (eg. I have "12/6/2011 1:01:21 PM" in my combo box list, i chose it but grid returns no result)

4. Normal Grid


Thanks & best regards

Shanmugaraja K [Syncfusion]
Replied On January 5, 2015 12:59 PM UTC

Hi Chong,


Thanks for your update.


We have created incident #133579 for this forum. Please follow through this incident.



Shanmugaraja 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

or the page will be automatically redirected to 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