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)
BO 4.3 Platform
Updated over a year ago
All CollectionsHelp ArticlesReporting in ETOFunctions and Formulas
ETO Results | Formula: Format Social Security Number
Did this answer your question?