Serial Numbers

[robrsla]

I'm tracking work orders by using an auto enter serial number. Each time we add a new project a new work order number is generated. We are using the work order numbers to track work assignments in the field and track our work with a paper trail. Now that the year is closing out I need a solution to the following. Can I set the numbers to be year specific. Example, I currently us the prefix 10 in a number field set next to the serial number so the work order number appears as 10- xxx I would like to set a solution to calculate the work order number based on the last 2 digits of the date (11 for next year) coupled by a auto entered serial number to appear the same way on our paperwork 11-xxx yet still be able to sort and search by prefix number and or know that a certain work order was generated in a certain year. ( I can reset the serial number to 1 at the start of each calendar year) thoughts suggestions, solutions or better ideas more than welcome.

[Matthew F]

Maybe you could keep your "SerialNumber" generator as is and define "WorkOrderNumber" as a text field with an auto-enter calculation:

Right ( Year ( Get ( CurrentDate ) ) ; 2 ) & "-" & SerialNumber

[Matthew F]

... or if you're want it to work past the year 2099,

Year ( Get ( CurrentDate )) - 2000 & "-" & SerialNumber

[robrsla]

Thanks, This worked like a dream. I had to change a few things around and re-work some reports but the concept and method you proposed will work better overall in the long run. One thing that holds me back is my lack of knowledge of what's available within this great program. Thanks for the solution.