Hello TO all Guru out there..

I am new to the asp.net and sqldatasource..,

I have use the sqldatasource in a code and i want to filter the recods based in on the date, using below function

But I always got an error!.

SqlDataSource1.FilterExpression = "[TARGET_DATE] = to_char(target_date,'mm/dd/yyyy') = to_char(to_date('" + txtSrchDate.Text.Trim() + "'),'mm/dd/yyyy')";

can somebody help me..??