1 Digit Month Designation Folgen

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 Kommentare
0
Avatar
Ian Cummings
Moderator
Aktionen für Kommentare Permalink

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
Aktionen für Kommentare Permalink

Ian,

Great, thanks for the help.

 

Ken

0
Avatar
Legacy Poster
Aktionen für Kommentare Permalink

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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.