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

Need most recently changed date only on open enrollment report

in Benefits 14 comments

Summary: We run 2 Open Enrollment reports, one which we send to our health provider partner.

During the OE period employees may change their benefits up to the deadline. When we run reports, it shows all the dates when staff have made changes. We need only the most recent date of their changes. How can we set parameters in the XX field to show only the most recently changed dates?

Content (please ensure you mask any confidential information): This is the field: "Benefits - Enrollments Real Time"."- Enrollment Results"."Election Date"

I found this reference, but am unsure how to use it in the Advanced SQL filter as it gave an error when used as is.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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