Max Effective Date Help

[flaaquileo]

I need to select max effective date in a health plan for employees. Employees have multiple health plan records. I believe the formula is
Maximum({EMPLOYEE_BENEFITS.EFFDT}, {EMPLOYEE_BENEFITS.EMPLID})
My report is grouped by EMPLID (employee).
I tried setting this up as a formula. I tried putting the criteria in my record selection.

This is a sample of my data

EMPLID, PLAN_TYPE, PLAN_CODE, START_DATE
12345678, HEALTH, EPO, 1/11/08
12345678, HEALTH, DP-EPO, 1/21/08
12345680, HEALTH, HMO, 1/11/08
12345680, HEALTH, HMO, 1/31/08
12345681, HEALTH, EPO, 3/30/08
12345681, HEALTH, EPO, 1/11/08

I want the following set returned:

12345678, HEALTH, DP-EPO, 1/21/08
12345680, HEALTH, HMO, 1/31/08
12345681, HEALTH, EPO, 3/30/08

How do you set up the Crystal report to select only max effective dates?
Can anyone help?
Thanks.

 

[lbass]

You've already been given the solution in another thread that you replied to thread767-1448563.

Also, why is that you have almost the same sample data as the original poster in that thread?

-LB