Hi Everyone,
I am a brand new user of Cognos.
Version:
IBM Cognos Analytics 11.1 R3I am currently trying to create an Expression Definition to filter my DateColumn to view data only from the previous complete month.
Whenever I try to run it, be it with HTML or Excel, no data is returned; and there are no errors when I validate the expression so I am unsure what is happening.
CODE:
[source].[datecolumn] in (_add_months(current_date,-1))
I have also tried to no avail:
- = (_add_months(current_date,-1))
- between (_add_months(current_date,-1)) and (_add_months(current_date,0))
I would appreciate some guidance or direction
Cheers
------------------------------
Jackey Tran
------------------------------
#CognosAnalyticswithWatson