I just joined the Salesforce Stack Exachange. Iam very much intrested in learning Salesforce and just entered into the world of Salesforce. I have a doubt in validation Rules. Can anyone please help me in this. I have created a Validation Rule of Closed Date should not be less than Today's date. [CloseDate <= TODAY()]. My question is "Only System Admins should have access to choose the Closed Date less than Today's Date??" Can anyone please help on this? Thankful in advance.

Thanks Rekha


2 Answers 2


Can you please also add one more condition
AND $User.ProfileId != "Admin profile id"
The most feasible will be just check the current user's profile in validation rule as below,
AND $Profile.Name != "System Administrator",

  • Hi Ravi, Thank you for the quick response. I just tried to implement the one which you said, " CloseDate <= TODAY() AND $Profile.Name!="System Administrator", it is showing the error Syntax error Extra AND. Can you please help me
    – Rekha
    Nov 17, 2017 at 9:31
  • Please use AND(CloseDate <= TODAY() , $Profile.Name!="System Administrator")
    – Ravi Kant
    Nov 17, 2017 at 9:49
  • Please mark it as answer, as it works. So thread will be closed here :)
    – Ravi Kant
    Nov 17, 2017 at 15:19

Give this a try !!

And( $User.ProfileId <> 'typeProfileIdHere' , ISCHANGED( close_dat__c ) , close_dat__c < Today() )


This site is temporarily in read-only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .