Need help with filtering data..

[RocAFella2007]

Hi, could somebody possibly help me out on some data filtering please. It keeps breaking on the following line:

dvfilter.RowFilter = String.Format("DateBorrowed LIKE '{0}*' ", _
txtenterdetails.Text)

with the error of:

Additional information: Cannot perform 'Like' operation on System.DateTime and System.String.

Any suggestions welcome. Thanks

 

[TipGiver]

Cannot perform 'Like' operation ...

I guess that you want to match 7/4/2007 with 7/4/* for example. This is not possible, as the one is date and the other is string. Use the >, >= orerators instead of LIKE. Also, i think that the date should be between #..#

 

[RocAFella2007]

Thanks buddy, ive solved it