Print Page - My Formula worked in cognos 10 with no errors now it does not in cognos11

Title: My Formula worked in cognos 10 with no errors now it does not in cognos11
Post by: MEB915 on 06 Dec 2022 05:24:49 PM

Any idea why the formula below is not working in cognos 11? It is giving me a UDA-SQL-0358 Line 15: Syntax error near ">="

[Expense].[Report Dates and Statuses].[Created Date] >= _add_days (current_date,-7)
and
[Expense].[Report Dates and Statuses].[Created Date] <= _add_days (current_date,-1)

Title: Re: My Formula worked in cognos 10 with no errors now it does not in cognos11
Post by: dougp on 06 Jan 2023 04:18:11 PM

If the expression has only 3 lines, the error can't be on line 15.

Keep in mind that the "validate" (check mark) button in the expression editor does NOT validate the expression. It validates the entire report.

Use More | Validate Report to get the list of validation errors.
Click on the first validation error and click "Select".
If you're lucky, Cognos will take you to the data item that is causing problems.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: MEB915 on 06 Dec 2022 05:24:49 PM