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.