Search found 3 matches
- Sat Feb 06, 2021 10:17 am
- Forum: Help
- Topic: Formatted SSN in reports
- Replies: 5
- Views: 5855
Re: Formatted SSN in reports
Using 12.6.5 - Professional Edition. I figured it out though. If you add a custom column to the report, set the formula to pre-group, set format to String. You'll use the following formula: string_concat('-', (string_substring(#sin#, 0,3)), string_concat('-',(string_substring(#sin#, 3,2)), (string_s...
- Fri Feb 05, 2021 2:21 pm
- Forum: Help
- Topic: Formatted SSN in reports
- Replies: 5
- Views: 5855
Re: Formatted SSN in reports
I am using Pay Stub Reports and the Deductions by Employee template. I am setting up the file to send to the company that handles our 457 retirement plan. They require the report have formatted SSN's (with the dashes). I thought I could create a custom column and fenagle a formula to do this, but I'...
- Fri Feb 05, 2021 2:09 pm
- Forum: Help
- Topic: Formatted SSN in reports
- Replies: 5
- Views: 5855
Formatted SSN in reports
Hello All,
I've searched the forum and didn't see an answer to this question. Is there a way to make a custom field in reports that will format the SSN appropriatly? (i.e. - 111-22-3333)?
I've searched the forum and didn't see an answer to this question. Is there a way to make a custom field in reports that will format the SSN appropriatly? (i.e. - 111-22-3333)?