I’m not at the computer right now, but I think I understand the problem. When you apply .Max() to a set of rows, it selects the max one NOT by filter condition (Max doesn’t know about filter condition at all) but perhaps by the display column (one with the bookmark icon).
You should try replace .Max() with .Sort(Date).Last() to get the row with max date. Or just .Date.Max() to only get the max date value, yeah