AnsweredAssumed Answered

Custom Serial number  by Calculation

Question asked by RobertT on Mar 2, 2015
Latest reply on Mar 5, 2015 by philmodjunk


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??