• Nikita Shatalaev
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
Hello, 

I need to create a validation rule that checks if the CloseDate of edited Opportunity is within specific date range and prevents saving if not. 
Here is the example of the rule I have and need to be modified: 

AND (
ISCHANGED(CloseDate),  
PRIORVALUE(CloseDate)>DATE(2015,9,30),
PRIORVALUE(CloseDate)<DATE(2016,1,1),
$Profile.Name <> "System Administrator")

So this rule prevents editing Close Dates of opportunities within current quarter if you are not system administrator. What do I need to add here to allow saving if CloseDate remains within current quarter, but still restrict it if it moves past December 31st 2015? 

I tried adding string CloseDate_c > DATE(2015,12,31) but that didnt seem to work. 

Ideas please? 
Hello, 

I need to create a validation rule that checks if the CloseDate of edited Opportunity is within specific date range and prevents saving if not. 
Here is the example of the rule I have and need to be modified: 

AND (
ISCHANGED(CloseDate),  
PRIORVALUE(CloseDate)>DATE(2015,9,30),
PRIORVALUE(CloseDate)<DATE(2016,1,1),
$Profile.Name <> "System Administrator")

So this rule prevents editing Close Dates of opportunities within current quarter if you are not system administrator. What do I need to add here to allow saving if CloseDate remains within current quarter, but still restrict it if it moves past December 31st 2015? 

I tried adding string CloseDate_c > DATE(2015,12,31) but that didnt seem to work. 

Ideas please?