Filter DateTime Column like a String

[Matthew]

I have a radgrid that auto generates its columns from a data table. I need to allow the user to enter a value in a textbox and search all columns of the grid for matches. I have the filter working for every column of the table that is pure text. The problem occurs with the date assigned column since it is not pure text but a datetime column.

The current Filter expression is:
WorkPackageGrid.MasterTableView.FilterExpression = "(([Title] LIKE \'%" + OtherFilter.Text + "%\')OR([Number] LIKE \'%" + OtherFilter.Text + "%\')OR([Status] LIKE \'%" + OtherFilter.Text + "%\')OR([ApprovalStatus] LIKE \'" + OtherFilter.Text + "\')OR([ScopeName] LIKE \'%" + OtherFilter.Text + "%\'))"

Is there a way to filter the datetime column based on the cells text value so all i need to add is "OR([DateAssigned] LIKE \'%" + OtherFilter.Text + "%\')" or convert the column to a pure text value so the same line would work?

[Matthew]

I was able to solve the problem by creating another row in my datasource datatable that was set to the toString() of the original date column. Then I hid the original column during prerender and ran the filter on the string column in case anyone else runs into this problem.