Validation rule: Candian_Postal_Codes_in_Address

Name

Candian_Postal_Codes_in_Address

Label

Candian_Postal_Codes_in_Address

Object

AQB__AQAddress__c

Active

No

Formula

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

Error message

Canadian postal code must be in A9A 9A9 format.

Error location

Postal Code