Forum Discussion
QuickBaseCoachD
Qrew Captain
Becky,
Try this
// desired format is ###-##-####
var text PartOne = Left([SSN],3);
var text PartTwo = Mid([SSN,4,2);
var text PartThree = Right([SSN],4);
IF(Length([SSN]=9,
List("-", $PartOne, $PartTwo, $PartThree))
Try this
// desired format is ###-##-####
var text PartOne = Left([SSN],3);
var text PartTwo = Mid([SSN,4,2);
var text PartThree = Right([SSN],4);
IF(Length([SSN]=9,
List("-", $PartOne, $PartTwo, $PartThree))
RobbinMarshall
6 years agoQrew Member
I found out the issue. I was missing the ")" behind [SSN].