Serial number Year
Hello,
One of my engineers (giving her the credit since I'm not doing it) is creating a label that includes a serial number (S/N) with the following digits:
- 5HRS0000
- 5 = last digit of the year
- HRS= location build
- 0000=sequential numbering
Is it possible to automatically increate the first digit (5) every year?
-
Hello,
Select "Clock" as the Data Type, then go to the Data Type tab and select the <<custom>> Format.
In Pattern, type in a capital Y.This will give you the last digit of the year (0-9).
Regards
/Joakim1 -
If you build the string out of three different substrings you can then source the data from different "places" . In this instance you would need to make the source of the first digit as Clock and then change the Type to Date and scroll down to the Custom option and setting the pattern to Y and so that will change every year automatically
1
Iniciar sesión para dejar un comentario.
Comentarios
2 comentarios