rwellsw
Active Member
I am new to JDE so don't be hard on me.
I am trying to create a event rule for a report that will take the social security number and have it print like xxx-xx-xxxx.
I have created the below event rule but all I get on the report is the first 3 digits. How do I get it to print all 9 digits plus put the - between the sections?
RV Variable 000021 = substr([BC Employee Tax ID (F060116)],0,3)+substr([BC Employee Tax ID (F060116)],3,2)+substr([BC Employee Tax ID (F060116)],5,4 )
Thanks
Roger
I am trying to create a event rule for a report that will take the social security number and have it print like xxx-xx-xxxx.
I have created the below event rule but all I get on the report is the first 3 digits. How do I get it to print all 9 digits plus put the - between the sections?
RV Variable 000021 = substr([BC Employee Tax ID (F060116)],0,3)+substr([BC Employee Tax ID (F060116)],3,2)+substr([BC Employee Tax ID (F060116)],5,4 )
Thanks
Roger