Nov 01, 2018 07:13 AM
I have a # field and I would like to have another field that ='s the first 3 digits of the #field.
Example. # field = 201-11-211. I would like to have another field that would = 201. The first 2 digits.
Nov 01, 2018 08:04 AM
Hi Vince
I hope I’m not missing something obvious - but can’t you simply use a formula field using the Left() function?
Nov 01, 2018 08:24 AM
THANK YOU. That’s is all I needed