May 26, 2022 12:38 PM
I have set up an automation to Update a Record from ‘Live’ to ‘Completed’
It has no errors so the logic works.
It is set up to change the status to ‘Completed’ if date is before ‘Yesterday’
For some reason I have a bunch of data that have a date before yesterday that just aren’t updating. Any ideas why?
May 26, 2022 01:05 PM
Hi @Laura_Vile ,
Can you check the date fields to see what time zone they are in? Sometimes they can be created in GMT timezone.
Also ensure the fields are of the type Date and not Text.
If none of those are the issue, can you post a screenshot of your automation and the dates you are expecting to update?
May 26, 2022 09:41 PM
Once you setup an automation, it will only work on newly-changed records that match your criteria. It doesn’t go back and update old records.
May 27, 2022 12:21 AM
Aaaah bingo!! Thank you!!
I thought it would change existing data, glad I asked otherwise I would have been there all night trying to figure it out!
May 27, 2022 01:36 AM
You’re welcome! Glad I could help! :slightly_smiling_face: