IBM Support

How to create a calculation for the start/end date of the previous month?

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.

Internal Use Only

Total SRs: 2 References: 2352281 3453943

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"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":""}]

Document Information

Modified date:
15 June 2018

UID

swg21340206