Show Only Maximum Current Year Enrollment Coverage Start Date
Summary:
I have an OTBI Benefits report that should show only current year max enrollment coverage start date . The Enrollment Coverage Start Date field has the below converted to SQL formula. How can this be modified to CURRENT YEAR MAX only?
("- Enrollment Results"."Enrollment Coverage Start Date") = MAX("- Enrollment Results"."Enrollment Coverage Start Date" BY "Worker"."Person Number")
Thanks for your expert advice!
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):