My question is how to configure the automatic numbering perception Next IAZR-14-AUG-10-0001 Where the first part is the fixed code Part II on today's date as the manual described The third part is automatic numbering which was increasing with the addition of each new record With a very pertinent observation Is that because the numbering of the beginning of (1), the first of each calendar year Enclose with an illustration of the solution Thank you very much
You may use the following expression to build the yearly changing number: Code: x = "IAZR-" & UCASE(FORMAT(DATE(),"dd-mmm-yy")) & FORMAT(dcount("*","employees")+1,"00000") Replace the Table Name Employees with your own.