Print Page - Last Completed Month Year as in Feb 2018 in Report Layout

Title: Last Completed Month Year as in Feb 2018 in Report Layout
Post by: cognos05 on 15 Mar 2018 10:19:38 AM

Hi ,

I would need to display the last completed month in report header . Can you guys tell is it possible to derive last completed month in MMM YYYY format .

I have the sample code which gives the last completed minus one date .

(timestamp2date( _add_days(date2timestamp(Today()), -1) ))

Thanks,
Nithya

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cognos05 on 15 Mar 2018 10:19:38 AM