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.
I am trying to use MAX to find out the latest date. MAX works for dates in a subtable, however in my scenario I would like to find the latest date from the subtable AND a stand-alone field.
I tried MAX(LASTA(C32),G31)
I also tried IF(LASTA(C32)>G31,LASTA(C32),G31)
but none of the above options worked for me.
C32 is a subtable
G31 is a stand-field