AnsweredAssumed Answered

sequential number based on year

Question asked by schematic on Dec 28, 2017
Latest reply on Dec 29, 2017 by schematic



I'm new to FM and realize this is a pretty basic question. We use the last 2 digits of the year and then a number sequence to number our jobs. So, 1801 will be the first job of 2018. Isolating the last two digits of the year was easy enough, but can't figure out how to add and incrementalize the 01, and so on. To isolate the date I have a field that is "job creation date" then a field with a calculated value "Right ( Job_Creation_Date ; 2 )".  To get the rest I tried various things to no avail.


Thanks in advance.