You need to sign in to do that
Don't have an account?
Charni Wiggins
Validation rule date cannot be after Today
Hi All,
I have a simple Val rule that I can't get working...
Cut_Off_INTERNAL_USE_ONLY__c is a formula field created from CreatedDate, gets the 4th day of next month. I need users to not be able to edit after this date...
Appreciate any help! :)
I have a simple Val rule that I can't get working...
Cut_Off_INTERNAL_USE_ONLY__c is a formula field created from CreatedDate, gets the 4th day of next month. I need users to not be able to edit after this date...
AND( TODAY() > Cut_Off_INTERNAL_USE_ONLY__c, ISCHANGED( TR1__Salary__c ), ISCHANGED( TR1__Fee_Percentage__c ), ISCHANGED( Extras_Amount__c ), $Profile.Name != "System Administrator (Finance)", $Profile.Name != "Cobalt Finance", $Profile.Name != "Talent Rover Administrator", $Profile.Name != "UK Manager Backbone" )
Appreciate any help! :)
All Answers
the second OR indicates that if the user's profile is not any one of System Administrator (Finance), Cobalt Finance, Talent Rover Administrator and UK Manager Backbone,
I don't understand why it shouldn't work in one AND though - all must be true.
Anyway, thank you very much, it works! :)