AnsweredAssumed Answered

getting latest data when there are multiple entries

Question asked by samxli on Jan 12, 2009
Latest reply on Jan 12, 2009 by ninja

Title

getting latest data when there are multiple entries

Post

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.

Outcomes