Troubleshooting
Problem
How to find the last date and the first date of the previous month in Report Studio?
Resolving The Problem
-Last day of the previous month can be determined by using the following expression:
_last_of_month(_add_months(current_date,-1))
-First day of the previous month can be determined by using the following expression:
_first_of_month(_add_months(current_date,-1))
Steps: -Open Report Studio-Create a calculation using the above mentioned expressions/functions.
Related Information
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.2;8.4.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21340206