If you are unable to create a new account, please email support@bspsoftware.com

 

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

Started by MEB915, 06 Dec 2022 05:24:49 PM

Previous topic - Next topic

MEB915

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)

dougp

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.