Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OTBI and pulling yesterday — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI and pulling yesterday

Received Response
11
Views
1
Comments

Summary:

Hi All,

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.

Content (required):

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.

Things like

TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE) 

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!