How to Filter a Date Column by Another Date Column — 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

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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