Hi all,
how to write the validation rule for above requirement, can you please help me on this ?

Hi all,

 I have to query to get the record count in objcet which is older than 2015 year. please help me with this .

Trigger TerritoryOwnerRestrictionTrigger on Territory__c (after insert,before Update) {
    for (Territory__c T : Trigger.new)
    {
       
      Integer i = [Select count() from Territory__c where Territory__c.OwnerId !=:T.OwnerId and Territory__c.Id !=: T.Id and Territory__c.Name=:T.Name];
        System.debug('Count :'+i);
      if(i>2)
      {
         T.addError('we can not Assign a zipcode to this user, Only a single zipcode is assigned to only three Owners.'); 
      }
    }
}

Hi all,
how to write the validation rule for above requirement, can you please help me on this ?

Field Name	Field Type	Description
Previous Owner	Lookup (User)	The prior sales rep assigned to this Account
New Owner	Lookup (User)	The new sales rep assigned to this Account
Previous Territory	Lookup (Territory__c)	The matching Territory__c record for the prior zip code
New Territory	Lookup (Territory__c)	The matching Territory__c record for the new zip code
Account	Master-Detail (Account)	The related Account record
Changed By	Lookup (User)	The user who changed the BillingPostalCode