Can not filter with MySQL function

[charin]

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.

[charin]

Okay, We 'll use FilterSql instead of Filter.

[AndreyZ]

This solution is correct.