cognosreport-studio

Date <> Currentdate


I am trying to apply a date filter form the query in report studio. Unfortunately, there is very limited documentation / pool of examples for Cognos and i'm stuck on what should be a simple problem.

How do I filter out records when xDate is not today? The below throws errors

[xDate] <> CURRENT_DATE() 

Replacing the operator <> with < or != also do not work.


Solution

  • Current_date does not have brackets, that is why your second iteration worked. You can also use localtime and localtimestamp.