Hi all,

I am attempting to create a validation rule for a birthday field (US) where the user has the ability to enter either MM/DD or MM/DD/YYYY. While I have the validation currently working, my issue is that the REGEX currently allows for months greater than 12 which is causing issues for data governance. Is it possible to have either a LEFT(Birthday__c, 2) < 12 or modify the Regex so that it does not allow for months greater than 12? Below is a sample of my rule:

 

NOT( 
OR( 
ISBLANK(Birthday__c), 
REGEX(Birthday__c , "[0-1]{1}[0-9]{1}/[0-3]{1}[0-9]{1}"), 
REGEX(Birthday__c , "[0-1]{1}[0-9]{1}/[0-3]{1}[0-9]{1}/[1-2]{1}[0-9]{1}[0-9]{1}[0-9]{1}") 
) 
)

 

Hey community, 

I have a field named "Company Legal Name". It's a different name than account name. Its important that we seperate between account name and company legal name. 

We switched to salesforce not to long ago. In our previous system, our employees used to search for the company legal name to identify a customer.
Is it possible to integrate the company legal name in the search bar? 

At the moment its only searching for account names, contacts, opportunities. 

 

Best regards, 

Niki