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.

FilterBar problem with DateTime Column

Thread ID:

Created:

Updated:

Platform:

Replies:

52480 Nov 29,2006 06:19 AM Nov 30,2006 01:44 AM Windows Forms 3
loading
Tags: GridControl
Simon Kakon
Asked On November 29, 2006 06:19 AM

Hi,
I have a problem when I apply a filter on a DateTime Column. The exception is "Cn not Perform '=' operation on System.DateTime and System.String".

Thanks for your haelp.
Simon

Administrator [Syncfusion]
Replied On November 29, 2006 06:46 AM

Hi Simon,

The GridDataBoundGrid uses a DataView.RowFilter property to handling the filtering that requires #''s around dates.

Here is a forum thread that discusses this.
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=29956

Best Regards,
Haneef

Simon Kakon
Replied On November 29, 2006 09:11 AM

The sample works fine.
But when I change the Format's cell ( Format = "d" or Format = "dd/MM/yyyy", it doesn't works with filter = #29/12/2006# ...

Maybe the filter format of field date is MM/dd/yyyy ??

>Hi Simon,

The GridDataBoundGrid uses a DataView.RowFilter property to handling the filtering that requires #'s around dates.

Here is a forum thread that discusses this.
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=29956

Best Regards,
Haneef

Administrator [Syncfusion]
Replied On November 30, 2006 01:44 AM

Hi Simon,

Yes. DataView.RowFilter doesn't support the other format. Please refer to the below forum thread for more details.

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic16245.aspx

Best Regards,
Haneef

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.

;