员工序列号，基于雇佣日期

Please assist amending the code below. what I want to do is creating unique serial number for each employee based on their hiring date eg. on was hired on 1/13/2016 the serial number comes with the last two digital number of (year,month,day+00) that means (16011300) for the one who hired in the same day and (year,month,day+01) that means (16011301)for the second one who hired in the same day. and do the same thing for those hired on different days. see pic below first what the code do but the second what I want it to be. thanks in advance for assistance the used code:Please assist amending the code below. what