AnsweredAssumed Answered

Find Duplicate ID, with newest start date, and mark old date to delete

Question asked by NancySpoolman on Jan 8, 2011
Latest reply on Jan 9, 2011 by NancySpoolman

Title

Find Duplicate ID, with newest start date, and mark old date to delete

Post

I have a file which contains five fields:

person ID

student ID

Eligibility Status

Start Date

End Date

I want to write a script that will find the unique student ID with the most current Start Date. Many of the student ID's are duplicated.

I can't use the counter and check duplicate calculation because it doesn't take in the date. I just don't know how to tell it to find the duplicate student ID with the most current date AND mark the other date to delete. 

I have searched several of the duplicate posts and comments, but I just can't get it to do what I think it should.

Thank you in advance.

Nanc

Outcomes