Salesforce

Validation Rule Formula Owner Name

Special Users to ignore validation rules, add a check box on User object: IgnoreValidationRules__c Then add following formula code to each validation rule formula:

Get Owner Name from Queue via formula:

And Owner Name when owner is User:

   

Salesforce

Salesforce Formula Calculate Years and Months Between 2 Dates

To calculate Years and Months in Salesforce formula field between 2 dates. Use case: Calculate how many years and months work experience from an employee start work date. Formula Field, return Text:

 

Salesforce

Change user password via Anonymous Apex Code

In case when user don’t have access to their email, and forget Salesforce password. Administrator can change the password by executing following line of code in the Execute Anonymous Window.

In Force.com Developer Console, press  Ctrl + E Execute above code, remember to replace Use ID and Password. Click Read more…