2 Different Date Format, One Prompt For The User

Legacy Poster

• January 11, 2013 07:54

Morning all,

On al specific labelformat, we need to enter the dates in the following formats:

DD MMM
JJMMDD

So, for example:

11 JAN (note that the month needs to be uppercase)
130111

However, I would like the user only to be prompted to insert one date and a script will generate the other format based on the input.

Is this possible ?

Thanks in advance,

Erik

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • January 14, 2013 16:35
  What version/build of BarTender is in use? Yes this will make a huge difference to the answer.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 15, 2013 10:44
  Hi Ian
  
  We are using BarTender Automation - Version 9.4 SR1 Build 2760
  
  Kind regards,,
  
  Erik

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • January 15, 2013 11:28
  I suggest you upgrade to the latest service release for starters:
  
  http://www.bartenderbarcodesoftware.com/label-software/fixes_94.aspx
  
  Unfortunately, there were many changes in v10 to make handling dates much easier, therefore we will need to do this the old way by VB script.
  
  In my example we will assume that the date prompt is under a sub-string share name of "btDate" which we can then reference in code:
  
  Value = DatePart("d", Format.NamedSubStrings("btDate").Value) & UCase(MonthName(DatePart("m", Format.NamedSubStrings("btDate").Value), True))
  
  Value = DatePart("y", Format.NamedSubStrings("btDate").Value) & DatePart("m", Format.NamedSubStrings("btDate").Value) & DatePart("d", Format.NamedSubStrings("btDate").Value)
  
  Note that instead of concatenating these VB script expressions into a single line, you could split them up into separate sub-strings to specify validation rules such as minimum number of digits padding on the left with zero when needed.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 16, 2013 08:38
  Thanks for your help so far Ian,
  
  I just tested this and this seems to work, however I need to do quite some with truncation and combining fields, but works.
  
  Thanks again,
  
  Erik

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • September 06, 2013 06:43

  I also would like some help with this type of problem.

  I need the date in the barcode and barcode human readable to be YYMMDD (SSCC format) and a 2nd text field to be DD/MM/YYYY from one user input.

   

  Any help

  Thanks

  David

  0
• 

  Canguita

  ★ BarTender Hero ★

  • September 10, 2013 15:55

  Hello David P.

   

  Thank you very much for your post.

   

  In this case that you can do is:

   

  1. Create a text in your label and provided it with a shared name (for example MyDate)
  2. Link this text with a Text Input Box
  3. In your BarCode add a VBscript as datasource with "Event Control Scripts" as Script Type. This VBscript should have this code in OnPostPrompt event

            Value = Format.NamedSubStrings("MyDate").Value 

   

  After on each object you will need to format the Date as you need.

   

  I've attached you a very simple file where you will find that you need.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • October 04, 2013 03:17

  Thanks for the demo file - That works for me

  0

Please sign in to leave a comment.