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

Change in field through validation rule

I have a date field(Date) and a picklist field(Status).
I want the validation as, when the date field is passed by a month and the status is not renewed then the status should change to expired.

Thanks in advance!

ShirishaShirisha (Salesforce Developers) 
Hi Nysha,


This can be done by creating the workflow rule by checking the values on both fields and update the value on the Status field.

You can only throw the error message using the Validation rule.So,you need to either use the workflow rule or Process builder to achieve this requirement.

Kindly mark it as best answer if it helps so that it can help others in the future.

Warm Regards,
Shirisha Pathuri

What should be the criteria that if the date exceeds than 30days.
i.e The date is 1/1/2020 and I want to check the criteria for 1/2/2020.
I  want the criteria to fire exactly after a month from the end date.

Peachey MyersPeachey Myers
Thanks for the information,keep sharing info like this