DataView RowFilter not working

Question

I am working on a simple database c# program. Using MS Access as end database. I have a form with datagridview, using Dataview as Datasource.

 

When I try to use DataView.Row filter, All operators (<, >, <=, >=) are working except = (equal) not working. My column datatype is DateTime. That part of the code is shown below.

 

Advance thanks, Please help.

string Today = DateTime.Now.ToString();
string FilterCmd = string.Format("ColumnName = #{0}#", Today);

Answer 1

Hey

 

I think the problem is with the date format, make sure your db date format matches the DateTime.Now eg. MM/dd/yyyy

 

Refer

https://stackoverflow.com/questions/3584571/compare-dates-in-dataview-rowfilter 

Answer 2

Hi,

 

check the below link where the date format for Dataview.Row filter is given.

 

https://forums.asp.net/t/1519078.aspx?How+to+format+a+Date+Field+in+DataView+RowFilter+to+consider+Date+only+Not+Time

 

Thank you