+ Start a Discussion
deepakMdeepakM 

validation rule to check the opp closed date ans set permission to edit specific field.

hi everyone

 

 i have one field in opportunity named closed date(close__date)

and one related list payinfo (related to opportunity)

 

so if opp closed date is greater thn the system date then if user edit the tax field and amount feild of payinfo the validation fire and keep the user not to edit these fields.

 

Opportunity field = closed__date.

payinfo fields taxe__c,amount__c.

 

 

please help me.

 

thanks

deepakMdeepakM

i did this

 

but it not work

 

AND(
Opportunity__r.CloseDate > DATE( YEAR(TODAY()), MONTH(TODAY()), 1) ,
ISCHANGED( Mileage__c) ,
ISCHANGED( Tax__c )

)

 

thanks

deepakMdeepakM

wheni used this

 

AND(
Opportunity__r.CloseDate > TODAY () ,
ISCHANGED( Mileage__c)
)

 

its work

 

but i need both the cases to check 

 

thanks

 

deepakMdeepakM

i got the sol:

 

AND( 
Opportunity__r.CloseDate > TODAY () , 
OR(ISCHANGED( Mileage__c) ,ISCHANGED(Tax__c) ) 
)