Earlier versions of Cognos recognized a date conversion function used against DB2 and SQL Server. That function is deprecated and has been replaced with the standard cast() function.
UDA-SQL-0219 The function "cast_date" is being used for local processing but is not available as a built-in function.
The cast_date function was used in earlier versions. More recent versions include the standard cast() function. The old function cast_date() is no longer supported.
DB2 and SQL Server data sources.
Resolving the problem
Modify the calculation or filter definition in the FM model or Report Studio report to change:
cast([dataitem] as date)