How to return a specific column value from a MAXROW() Expression

[SHAR8F]

Hello,

I need to return only the date from this expression

MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME]))

and compare it to

TODAY().

Example, a certain event will happen only if The Date Value, from the date column, of the row returned by
MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME])) is before TODAY().

Thanks