I have been attempting to simply change the data type of a column for a query I am running through the ProvideX ODBC but I keep getting errors, and I am wondering if this scalar function is not available here. Simply, I am trying to query the IM_PeriodPostingHistory and convert the FiscalCalYear to a number as opposed to a string, which would enable me to pre-filter based on the FiscalYear being within the last 2 years (using the {fn YEAR({fn CURDATE()})} functions). We use the PVX ODBC to create Excel reports off our SAGE data, and was hoping to leverage this to lighten the data pull a bit.

Any ideas or is this a hard limitation? TIA!