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

Cognos 10 Business Intelligence Report Studio
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: