Can't apply a filter to a date field

An error occurred while communicating with the Other Databases (ODBC) data source 'Custom_SQL_Query (CData)'.

Bad Connection: Tableau could not connect to the data source.
[400] 05220226 Unable to execute the query, error caused by: Cannot apply 'EXTRACT' to arguments of type 'EXTRACT(<INTERVAL YEAR> FROM <JAVATYPE(CLASS JAVA.LANG.STRING)>)'. Supported form(s): 'EXTRACT(<DATETIME_INTERVAL> FROM <DATETIME_INTERVAL>)'
'EXTRACT(<DATETIME_INTERVAL> FROM <DATETIME>)'. 
SELECT `Custom_SQL_Query1`.`TYPE` AS `TYPE`,
 SUM(`Custom_SQL_Query1`.`cm_content.size`) AS `sum_cm_content_size_ok`,
 \{fn YEAR(`Custom_SQL_Query1`.`cm_modified`)} AS `yr_cm_modified_ok`
FROM (
 select *, expense_Amount from alfresco
) `Custom_SQL_Query1`
 INNER JOIN (
 SELECT \{fn YEAR(`Custom_SQL_Query1`.`cm_modified`)} AS `yr_cm_modified_ok`
 FROM (
 select *, expense_Amount from alfresco
 ) `Custom_SQL_Query1`
 GROUP BY \{fn YEAR(`Custom_SQL_Query1`.`cm_modified`)}
 HAVING (MIN(`Custom_SQL_Query1`.`cm_created`) > \{ts '2020-04-22 00:00:00'})
) `t0` ON ((\{fn YEAR(`Custom_SQL_Query1`.`cm_modified`)} = `t0`.`yr_cm_modified_ok`) OR ((\{fn YEAR(`Custom_SQL_Query1`.`cm_modified`)} IS NULL) AND (`t0`.`yr_cm_modified_ok` IS NULL)))
GROUP BY `Custom_SQL_Query1`.`TYPE`,
 \{fn YEAR(`Custom_SQL_Query1`.`cm_modified`)}