Formula for Latest Date | Subtable

I am looking for a formula that will display the latest date from a subtable column.

A similar one that I have displays the last entry’s data, Last(A10), but I can’t get this to work for dates. The other thing is that it’s not necessarily the last entry as the date is not for when it was created but for an event. So, the last entry’s event date may not be the latest date.


Please try MAX() to get the latest date in stand-alone field, with date field type. :slight_smile:


I’m not sure why it wasn’t working at first, but somehow it is now.

Thank you so so so much!! This is going to be a huge help for two things for my admin team :smiley: