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.
Unfortunately, activation email could not send to your email. Please try again.

Filter On Date Column

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hi,

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 07:57 AM

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)

 

Regards,

Shanmugaraja K


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

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 07:59 AM

Hi Chong,

 

Thanks for your update.

 

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

 

Regards,

Shanmugaraja K

CONFIRMATION

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.

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.

;