Automations: IF statement test for each row


I have a simple table with a date column.

I would like an automation that does the following:
When? Every day at 9AM -> this is working obv

What trigger?
for each row
if date column < today ()

This is where the issue arrises. If I select my column, it gives me an array of dates. How do I test the whole array against Today()? If any of the array is lower than today, the automation should be triggered.

Thank you,

Is this what you were trying to do ? :blush:

I’ve tried this in a “Test table” Table 1 where 2 of the dates are <Today()

This is if the Date column is set as display. If it’s not the case, it returns this :