function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SFSF 

update picklist value from a separate date field comparing to today's date

We have a status standard picklist. we want it changed to a picklist value Expired. This should change based on a separate standard datefield. When this date field passes Today()  we would like the picklist value to update.  I tried record trigger flow but it is updating only when the record is created or updates. Tried autolaunch flow and getting this error
The flow tried to update these records: 8004M0000015XHhQAM. This error occurred: FAILED_ACTIVATION: Choose a valid contract status and save your changes. Ask your admin for details.. You can look up ExceptionCode values in the SOAP API Developer Guide.

the error occurs on this step

User-added image

we want it to update automatically without any record creation or update. Any help would be appreciated!
Thank you
Best Answer chosen by SF
PriyaPriya (Salesforce Developers) 
Hi ,

Can you please refer the below where the ask is to use Time-Dependent Workflow Action .
https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A80gVSAR

Hope this is helpful..Please mark this as best answer!!

Regards,
Ranjan