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

OBIEE: Calculate when candidate moved into status more than 24 hours prior to Current Date

Question
29
Views
0
Comments

Content

Good Afternoon

I'm working on a few reports where I have created a calculation from when a candidate moved into a specific status more than 24 hours prior to the Current date.

Here is what I've created in OBI using a SQL Expression:

Current Status Start Date > Current_TimeStamp - 24

My results are consistently bringing back everyone in that particular Step/Status instead of using the criteria above.

I'm very new to OBI, so I'm wondering if I'm not using the correct expression for 24 hours from the Current_TimeStamp. 

Any advice!? Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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