OTBI and pulling yesterday
I must admit I am pretty bad with dates in OTBI. I am attempting to build a report that will pull something entered the day before.
I am attempting to pull data from a field entered day before. so lets pretend field is called entered date. I want to dynamically always pull yesterdays. I have tried and read a few options but none get me right.
but they just do not work.
Whats a best way to pull all entries from day before today dynamically such that you dont have to enter day every day?