Get the recent date from the mirrored column and cast it to the Date column

Hi, has anyone pulled one item (particularly date) from the mirrored column with multiple items linked and cast it to the Date column?

I have this board having one item linked to multiple transactions from the other board. I want to get the latest date from the mirrored column and cast it in the Get recent date column using General Caster automation but I can’t capture the recent date.



I need this setup to use the Date column in creating Automation, mirrored column is not supported in Automation.

Tried selecting just the mirrored column, and using the Max() function from the formula but it didn’t give me the right outcome.

I hope someone here has an idea without any coding required.