1 Digit Month Designation
Has anyone used a single digit to designate the month in a serial number? I think this would be like a base 12 numbering system that uses "C" for December and resets back to a 1 in January.
The serial number format is MYYXXXX (9150001).
M = month
YY = 2 digit year
XXXX = 0001 (incrementing 4 digit base 10 serial number).
Set-up your month code like usual for the single M digit. However, enable the OnProcessData VB script for the data source via the "Transforms" tab, and enter in the below Select statement:
Select Case value Case 10 value = "A" Case 11 value = "B" Case 12 value = "C" End Select0
Great, thanks for the help.
Today was the real world test and VB passed.
This is the first time I did anything with VB and it gave me interest in looking further into what else it can do.
Please sign in to leave a comment.