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