I need to hide all but the last four digits of a patient's SSN. Does anyone have the formula for this?
Thanks
"***-**-" + Right({PERSON.SOCSECNO}, 4)
jjordet said:
"***-**-" + Right({PERSON.SOCSECNO}, 4)
Perfect!
Thank you
jjordet said:
"***-**-" + Right({PERSON.SOCSECNO}, 4)
Hi Jerroll,
Question: How would I instert this into the translation box in VFE. Currently I have :
{CFMT(STR(PATIENT.SOCSECNO),"","SSN#:","B","
")}
{CFMT(SUB(PATIENT.SOCSECNO, 6, 4),"","SSN#: ***-**-","B","
")}
jjordet said:
{CFMT(SUB(PATIENT.SOCSECNO, 6, 4),"","SSN#: ***-**-","B","
")}
It is now displaying like this: SSN#: ***-**-123-45-678964
The social being used is 123-45-6789
are you sure you're using SUB and not STR?
jjordet said:
are you sure you're using SUB and not STR?
Thank you! It worked.