How to Filter a Date Column by Another Date Column
Summary:
I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show the Benefits plan elected by the individual at the time that this action was started in Benefits - Enrollments Real Time .
The current issue is that the report runs but for each employee it shows all Plans elected at any time. I want the report to only show plans that are active as of the Effective Start Date of the Action. Logically, what I would do is add a filter that says "Assignment Effective Start Date is between Enrollment Coverage Start Date and Enrollment Coverage Through Date." I can not get this to work.