Validation rule: Valid_Canadian_Provinces_in_Address

Name

Valid_Canadian_Provinces_in_Address

Label

Valid_Canadian_Provinces_in_Address

Object

AQB__AQAddress__c

Active

No

Formula

AND(
OR( AQB__Country__c = 'CN',AQB__Country__c="CAN",AQB__Country__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__StateProvince__c )))

Error message

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

Error location

State/Province