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.
Current_date does not have brackets, that is why your second iteration worked. You can also use localtime and localtimestamp.