RollupMax on Date field

Hi,

I want to add logic to an opportunity field (service end date) that auto-populates the maximum date of the related RLIs.

The BPM doesn't allow looping through the associated RLI records. Furthermore, the ROLLUPMAX function doesn't support a date field to apply the sugar logic/calculated field.

How can I achieve this?

Best regards,

Gayathri G