getting latest data when there are multiple entries
I have a table that displays the graduation dates of students from different institutions.
I am creating a script that checks whether a student has graduated within a certain date range, but some students might have graduated from multiple institutions. For example, one student graduated from 3 different institutions and the dates are 9/15/2008, 11/14/2007, and 11/29/2005. When I run my script to get the graduation date, it only returns the 11/14/2007 date. How do I make it so that it returns either the latest date or the earliest date?
Note: I tried using the Max() function but it did not return a proper date value.