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

in Reporting and Analytics for HCM 1 comment

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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