Validation rule: Canadian_Postal_Codes_in_Shiping_Address

Name

Canadian_Postal_Codes_in_Shiping_Address

Label

Canadian_Postal_Codes_in_Shiping_Address

Object

Account

Active

No

Formula

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

Error message

Canadian postal code must be in A9A 9A9 format

Error location

Account.ShippingPostalCode