If you use grouping, could you just set Maximum as the group for that date field and return that fxamount?