cancel
Showing results for 
Search instead for 
Did you mean: 
viv_prabha
Occasional Member - Level 1

Expression to get two month data for auto scheduled Cognos Report

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

 

1 REPLY 1
KevinD
Community Manager
Community Manager

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


Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.