You need to sign in to do that
Don't have an account?
force shahid
Validation rule for date field when year only changed
Hi friends,
I want to create a Validation rule in opportunity object. When year is changed in Close Date field in Opportunity object , i need to display error msg to fill the reason into another field.
How to write VR for this one.
VR for only year changed in Close Date field
I want to create a Validation rule in opportunity object. When year is changed in Close Date field in Opportunity object , i need to display error msg to fill the reason into another field.
How to write VR for this one.
VR for only year changed in Close Date field
Let me inform if it helps you and kindly mark it best answer if it helps you so it make proper solution for others
thanks
sfdcmonkey.com
All Answers
Let me inform if it helps you and kindly mark it best answer if it helps you so it make proper solution for others
thanks
sfdcmonkey.com
Thank you so much. It's Working.
Thanks,
Shahid.
ABove condition is working .
y exact requirement is when i change year in close date then i need to select one value from picklist field.
I write a VR , its working only if picklist field is empty.
But my requirement is when year is changed , then enter the picklist field.
VR :
AND(YEAR(CloseDate) <> YEAR(PRIORVALUE(CloseDate)),
ISPICKVAL(Push_reason__c,)
)
Thanks
Thanks ,
ShahidHi Piyush,
Its working only on Push_reason__c picklist field is empty. If Push_reason__c field have a value , and year is changed in close date field , then error message is not display.
My requirement is : When year is changed in Closed Date field , then show the error msg in to Push_reason__c field , if it has value or not .