1 Digit Month Designation

Legacy Poster

• September 22, 2015 21:48

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

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • September 23, 2015 09:23

  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • September 23, 2015 18:58

  Ian,

  Great, thanks for the help.

   

  Ken

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • October 01, 2015 15:37

  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

  0

Please sign in to leave a comment.