It looks like you have put the Status field where you should have put Record ID. Set it like this…

Thanks @augmented! I knew it was something simple like that.

Now, when I run the tests, it says it’s successful on both the Trigger and the Action. But, when I turn the Automation on, it’s not updating the records, they’re staying the same as what I’d entered in that field before. And, if I create a new record, and assign it a date, it maintains its default value from the Single Text field type that I’d set, rather than adjusting it based on its age.

Is it possible that my trigger of When Date Is Before/After One Week Ago isn’t recognizing the dates in my Date field? I created an Automation for Before One Week Ago, and a second Automation for After One Week Ago so it should assign Old and New appropriately. Neither seem to be triggering.

Thanks again!

You can look in the test of your trigger to see what record(s) matched the conditions. There’s a lot of info in there.

“on or after” “one week ago” should fire for dates 1/15/2021 (ish) and newer right now. I just tried your automation and it worked for me.

Thanks for testing it! It does work on new records created after turning on the Automation, but I suppose I thought it would update existing records to meet the new criteria. I can live with this as a solution, I just need to create my Automations before I enter my data.

If there’s another workaround to getting it to update existing records, let me know! Thanks again!

Automations run only once while a record matches the condition in the trigger. So, I think if you change the date so that it no longer matches the condition, and then change it back, it should fire again.