Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How do i filter my report data to only get results for current date - 1

Hey All,

I was wondering if there is a formula that can be written at the BO report level where i can only filter the results for Date > = Current Date - 1

Basically, I have a Date field on my report that has historical data and goes back a few years.

I do not wish to see all of this data on my report and wanted to know how can i filter this Date to see anything that is greater than yesterday's date only?

Any help is highly appreciated.

Thanks

Former Member
replied

Hi

create a variable like this..

Var=if((date)>=relativedate(curdate();-1)) then "A"

apply filter in the table where Var variable is equal to A

Amit

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question