1 Digit Month Designation 追蹤

0
Avatar
Legacy Poster

Hi,

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).

 

Thanks,

Ken

3 意見

0
Avatar
Ian Cummings
版主
評論操作 永久連結

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 Select
0
Avatar
Legacy Poster
評論操作 永久連結

Ian,

Great, thanks for the help.

 

Ken

0
Avatar
Legacy Poster
評論操作 永久連結

Ian,

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.

 

Thanks again,

Ken

登入寫評論。