UDA-SQL-0219 The function "cast_date" is being used for local processing

Technote (troubleshooting)


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)

Related information

Cognos Upgrade Central
Dynamic Report Updater

Rate this page:

(0 users)Average rating

Document information

More support for:

Cognos Business Intelligence
Report Studio

Software version:

10.2, 10.2.1

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation