Devart Forums

I try to filter the table with following statement

Filter := 'DATE_FORMAT(DATETIME_IN, '%Y%m') BETWEEN 201111 AND 201211 ';

MyDac said: column "DATE_FORMAT" not found"

How can i solve this issue?

Thanks.

Okay, We 'll use FilterSql instead of Filter.

This solution is correct.