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?
Automation to Change Status
+6
+16Hi @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?
+35Also:
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.
+6Also:
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.
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!
+35Aaaah 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!
You’re welcome! Glad I could help! :slightly_smiling_face:
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.