I am scratching my head over something rather stupid yet apparently difficult.
DataView dvFormula = dsFormula.Tables[0].DefaultView;
dvFormula.RowFilter = "'" + startDate.ToString("yyyyMMdd") + "' < EndDate OR EndDate = '19000101'";
dvFormula.Sort = "FromDate ASC";
The result is this:
Cannot perform '<' operation on System.String and System.DateTime.
Please tell me what the best way to solve this problem would be.
Much appreciated!