Validation rule: Valid_Canadian_Province_in_Perm_Address

Name

Valid_Canadian_Province_in_Perm_Address

Label

Valid_Canadian_Province_in_Perm_Address

Object

Account

Active

No

Formula

AND(
OR( AQB__AccountDefaultCountry__c = 'CN', AQB__AccountDefaultCountry__c ="CAN", AQB__AccountDefaultCountry__c ="Canada"),
NOT(CONTAINS("AB:Alberta:BC:British Columbia:MB:Manitoba:" & "NB:New Brunswick:NL:Newfoundland and Labrador:" & "NT:Northwest Territories:NS:Nova Scotia:NU:Nunavut:" & "ON:Ontario:PE:Prince Edward Island:QC:Québec:Quebec:SK:Saskatchewan:YT:Yukon", AQB__AccountDefaultStateProvince__c )))

Error message

Either a valid two-letter Canadian province code or the full name of the province is required.

Error location

Permanent Address State/Province