Validation rule: Canadian_Postal_Codes_in_Perm_Addres

Name

Canadian_Postal_Codes_in_Perm_Addres

Label

Canadian_Postal_Codes_in_Perm_Addres

Object

Account

Active

No

Formula

AND(
OR( AQB__AccountDefaultCountry__c = "CA", AQB__AccountDefaultCountry__c = "Canada", AQB__AccountDefaultCountry__c ="CN"),
NOT(REGEX( AQB__AccountDefaultZipCode__c , "((?i)[ABCEGHJKLMNPRSTVXY]\\d[A-Z]?\\s?\\d[A-Z]\\d)?"))
)

Error message

Canadian postal code must be in A9A 9A9 format.

Error location

Permanent Add Zip/Postal Code