FilterBar problem with DateTime Column

Question

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 · Answer

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 · Answer

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 · Answer

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.aspxBest Regards,Haneef