ssn format

[sbcsandhu]

i cant rememeber how i would format the dashes(-) in a SSN

123456789

would like it 123-45-6789

thanks

 

[AndyMc]

Try:

//@ssn formula
picture({table.ssn},"xxx-xx-xxxx")

Andy

 

[AndyMc]

That was assuming the ssn was a text field. If its numeric try:

//@ssn formula
picture(totext({table.ssn},0,""),"xxx-xx-xxxx")

Andy

 

[lbass]

If it's a number, then I think you should use:

picture(totext({table.ssn},"000000000"),"xxx-xx-xxxx")

--in order to get the leading 0.

-LB

 

[AndyMc]

Oh yea, I forgot about the those folks born in the top-right-corner of the country - thanks for catching that, LB.

Andy