Formula to choose the latest date? 1

[ggies07]

Hello,

I'm dealing with enrollment dates. Some students leave and then come back so they then have multiple enrollment dates. The online database we use can not pull the latest one, so is there a way to do this in a formula?

Say a student enrolled in 2018, left, but then came back last year (2020). I need the latest one, 2020.

Otherwise, the report creates dups of the students because they are listed multiple times in the excel I use...

Something like: if {enrollment.date} is the latest then {student.name}....just don't know what to use there...

Thanks.

 

[lbass]

Insert a group on the student field and then use group selection. Go to report->selection formula->GROUP and enter:

{table.enrollmentdate}=maximum({table.enrollmentdate},{table.student})

This will display data for only the most recent enrollment date, but note that all enrollment data will be in the underlying report data, just not displayed.

-LB

 

[ggies07]

awesome! I thought it could be done, just didn't know what criteria to use. Thanks so much! You are a life saver of work because I was going to have to go another route, which included entering data in a new place, if I couldn't get this figured out.

Much appreciated.

Cheers.