Support for DAYOFMONTH, DAYOFWEEK, DAYOFYEAR

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] 05220197 Unable to execute the query, error caused by: Cannot apply 'EXTRACT' to arguments of type 'EXTRACT(<INTERVAL DOY> 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(1) AS `sum_Number_of_Records_ok`,
 {fn TIMESTAMPADD(SQL_TSI_DAY,{fn FLOOR((-1 * (

{fn DAYOFYEAR(`Custom_SQL_Query1`.`cm_created`)} - 1)))},CAST(`Custom_SQL_Query1`.`cm_created` AS DATE))} AS `tyr_cm_created_ok`
 FROM (
 select *, expense_Amount from alfresco
 ) `Custom_SQL_Query1`
 GROUP BY `Custom_SQL_Query1`.`TYPE`,
 \{fn TIMESTAMPADD(SQL_TSI_DAY,{fn FLOOR((-1 * ({fn DAYOFYEAR(`Custom_SQL_Query1`.`cm_created`)}
 - 1)))},CAST(`Custom_SQL_Query1`.`cm_created` AS DATE))}