CODEWITHSUNDEEP
cognosreport-studio
urdearboy
urdearboy

Reputation: 14580

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.

Upvotes: 0

Views: 232

Answers (1)

Daniel Wagemann
Daniel Wagemann

Reputation: 851

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

Upvotes: 2

Related Questions