Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

The operation "subtract" is invalid for the following combination of data types:


#1

Hello Guru,

I need some help with this message below we are using Cognos 10.2.1 Oracle database.

UDA-SQL-0460 A general exception has occurred during local processing.
UDA-EE-0094 The operation “subtract” is invalid for the following combination of data types: “date2” and “integer”

This filter that is causing this issue is:
((_day_of_week(cast(current_date,date),1) = 1 and cast([A75I Payroll].[SYSTEM_AUDIT_TRAIL].[TIMESTAMP],date) >= _add_days(cast(current_date,date),-3)) or ( _day_of_week(cast(current_date,date),1) <> 1 and cast([A75I Payroll].[SYSTEM_AUDIT_TRAIL].[TIMESTAMP],date) = _add_days(cast(current_date,date),-1)))

I’m just not sure how to change this to work on an Oracle database.

Thanks, in advance for your help/support

Linda :slight_smile: