Filter Widget Error

1

I am getting the following error when using filter widget by setting default value in the SQL query itself.

Internal error: MCS-2030: Predicate and Logic operators can not be used where an expression is expected.

I am using this code in where clause

date_format(created_date, '%M %Y') = [[ {{created_date}} #]]date_format(current_date(), '%M %Y')

2

Seems you can’t use logic on both sides of the expression

3

Also tried the other way round. Still getting the same error.

4

You can’t use logic on both sides of the expression, you need to use logic on only one side