Logical SQL Statement for OBIEE to pull future date
SummaryNeed a report listing employees who will be starting 5 days in the future
I have created a report that shows any candidate who has not completed their onboarding. I need to add a sql filter that pulls only those candidates who have not completed their onboarding and starts in 5 days (on the following Monday).
Right now I have a statement filter that is > current_date which gives me anything greater than current date but would like to further filter to just 5 days ahead.
Any help would be greatly appreciated.