I have a membership directory which has a status that I want to update based on the expiry date. I have created an automation that:
Triggers at a specific time (In the screenshot you'll see it is Sunday (Today) at 2pm but I have tried one time, hourly and others)
To find records where the expiry date field IS today and the Status is Active (I have also tried it without this condition as it's a bit redundant and only is of use if a record has been set to expired manually and therefor doesn't need the automation)
Update Status to Expired.
I have deleted and started again and tried different combinations but can't get it to work. Does updating a field not work with a time trigger?
When I get it to work I will have it running at 12:15am each day.
