
Need help with a Validation rule to check if Opportunity name field contain a value/number - 15 in the opportunity name format.
We use opp naming convention as 1SCM15, 2SCM15 etc i.e. ending with last two digits of current year, so I need to restric sales users from entering opportunity name as 1SCM14, 2SCM14, LF14 etc. It should contain 15 and not 14 at the end.
Please can someone help me with this?
Thanks,
swapnil
8 answers