Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OBIEE: Calculate when candidate moved into status more than 24 hours prior to Current Date — 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

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

Question
30
Views
0
Comments
edited Dec 13, 2022 6:59AM in Taleo Enterprise

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!