Forum Discussion
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))
- I tried this and received an error on the "If(Length" line. The error states "The operator '=' can't be applied on types text, number"
My SSN field was a numeric field, but I had to change it to text to fix the errors in the first 3 lines that begin with "var" - I found out the issue. I was missing the ")" behind [SSN].
