Expression to get two month data for auto scheduled Cognos Report

[viv_prabha]

Hi,

I am trying to get report on 5th , 10th, 25th, 28th and 30th of each month and data period is 2 months of data. e.g. 7/30/2022  to 9/29/2022.

I have created below filter expression but getting error

[Expense].[Credit Card Transactions].[Download Date] between _make_timestamp ( year (_add_months (current_date, -1)), month (_add_months (current_date, -3)), 30) and [Expense].[Credit Card Transactions].[Download Date] <= current_date

Please suggest what is incorrect and how to fix the error. 

Regards

Vivek

[KevinD]

@viv_prabha replied to your private message. Awaiting your response.