SSN Formula

[TechUser23]

My current formula:

IF TRIM({rpPatProfile.PatientSSN})<>"" THEN
MID({rpPatProfile.PatientSSN},1,3)+"-"+MID({rpPatProfile.PatientSSN},4,2)+"-"+MID({rpPatProfile.PatientSSN},6,4)

My client would like to have it formatted only to print the last digits of the patient SSN#. So instead of 123-45-6789, I would like this to show as *****6789.

 

[Turkbear]

Hi,
You are close already, use:

IF TRIM({rpPatProfile.PatientSSN})<>"" THEN
"*****" + MID({rpPatProfile.PatientSSN},6,4)

To Paraphrase:"The Help you get is proportional to the Help you give.."