So, in Cognos Report Studio i have a query item with this expression that is getting me an error that i still need to figure out. The expression is this:
IF (( current_date - [Submission date]) > 30) then ('Yes') ELSE ('No')
And the error is this:
UDA-EE-0094 The operation "greater" is invalid for the following combination of data types: "interval2" and "integer"
[Submission date] in the framework level its used as an attribute and in the format is formatted as a date in 'Date Style'
AS i don_'t know if you have native sql enabled and the could use
DATEDIFF
.use the Cognos function
_days_between()