@kochar - You can calculate max date of a field using the maxOver function - maxOver({your date field}, [ ], PRE_AGG).
Here’s a link to an article with more details on usage.