Most Recent Event Based on Date
Why can't you use the MAX() function?

I did the following

mysql&gt; CREATE TABLE fred (myd date);
Query OK, 0 rows affected (0.31 sec)

mysql&gt; INSERT INTO fred VALUES('2015-10-05');
Query OK, 1 row affected (0.06 sec)

mysql&gt; INSERT INTO fred VALUES('2014-10-05');
Query OK, 1 row affected (0.07 sec)

mysql&gt; SELECT MAX(myd) FROM fred;
+------------+
| MAX(myd)   |
+------------+
| 2015-10-05 |
+------------+
1 row in set (0.00 sec)


MAX(myd) works perfectly. Could you show where "I can't get MAX() to function with this." is failing, along with the error message?