Hello,
How to use the day of the year in a batch/series number formula. For example, today is 03/29/2022, so on the 88th day of the year, I would like my lot/serial number start with 2022/088.
Answer
How to use the day of the year in a batch/series number formula?
Best answer by angierowley75
According to the help file (for Lot/Serial Classes), the custom format syntax leverages custom date specifiers from .NET
From what I can tell the day # of the year is not supported
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
+3You would need to setup a Lot/Serial Class (IN207000)
Assign the “Issue Method” field as “user enterable”
And define your number segment (grid at bottom of the screen) to start with the year. You will need to manually enter the day of the year as that is not a default segment function.
I would recommend setting up a new Lot/Serial class in your sandbox and running through a few tests to see how it behaves to figure out the best fit for your business.
If I have helped you, please ~ *Like* my post. If I have provided an answer to your question, please mark it as *Best Answer* . Thank you!
Thanks AngieRowley75 for your answer.
I would like to know if there is a way to automate the day of the year segment, for example by using the Custom Date Format type.
+3According to the help file (for Lot/Serial Classes), the custom format syntax leverages custom date specifiers from .NET
From what I can tell the day # of the year is not supported
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.