function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AgzazAgzaz 

Prevent changing date validation rule

Hope someone can help me.

 

I need to create a validation rule for this scenario:

 

User "A" creates a record in custom object and leaves Compromise Proposal Date field blank. This field is Date type.

User "B" enters the record and types a valid date in Compromise Proposal Date field.

Once user "B" enters a date, no one must be able to modify it.

 

Thanks 

KrishnadasKrishnadas

Hi,
 
You could try to doing the following
LastModifiedBy.LastName = 'User B' && ISCHANGED(Date__c)

Doing this will allow users to enter new values for the date field but will effectively stop saving the record and provide an error message.

 

Thanks
Krishnadas
Steadfast Global
www.steadfastglobal.com