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..??


Mico