Custom Serial number by Calculation
I'm trying to figure out how to create a calculation serial number.. I have a table with field of first name, and last name, and the date of when patient first starting seeing the doctor. I want the serial number to equal the first 3 letters of the last name and first 2 letters of first name and the two digit year (15 etc) when they joined followed by a zero. Is this doable??