All Collections
ETO Results 4.3
Formulas and Objects
ETO Results | Formula: Formatting SSN
ETO Results | Formula: Formatting SSN

BO 4.3 Platform

Updated over a week ago

SSN Formula

US Customers:

=If Not(IsNull([SSN])) Then Left([SSN];3)+"-"+Substr([SSN];4;2)+"-"+Right([SSN];4)

CA Customers:

=If Not(IsNull([SIN])) Then Left([SIN];3)+"-"+Substr([SIN];4;3)+"-"+Right([SIN];3)

Did this answer your question?