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
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.