Date Format In Code 128 Barcode Follow

0
Avatar
Legacy Poster

Hello,
I need to create a code 128 barcode containing dates and times from database filds. The dates on tha database are dd.mm.yy and in the barcode i need them to be yymmdd (different order and no points). The time variables in the database are hh:mm and in the barcode i need them to be hhmm (no points).
Couid you please tell me how to do this ?
Thank you,
Michal

3 comments

0
Avatar
Legacy Poster
Comment actions Permalink

[quote name='Michal' timestamp='1356342982' post='3971']
Hello,
I need to create a code 128 barcode containing dates and times from database filds. The dates on tha database are dd.mm.yy and in the barcode i need them to be yymmdd (different order and no points). The time variables in the database are hh:mm and in the barcode i need them to be hhmm (no points).
Couid you please tell me how to do this ?
Thank you,
Michal
[/quote]

Hi

If possible I would recommend changing the database to have three separate files, dd, mm, yy, I would then use the substring wizzard to concatanate the three fields in your preferred order.

Thre may me another way,, but this is what I would try in the first instance.

Regards

Rob
0
Avatar
Michael Toupin (mtoupin
Comment actions Permalink

[quote name='Michal' timestamp='1356342982' post='3971']
Hello,
I need to create a code 128 barcode containing dates and times from database filds. The dates on tha database are dd.mm.yy and in the barcode i need them to be yymmdd (different order and no points). The time variables in the database are hh:mm and in the barcode i need them to be hhmm (no points).
Couid you please tell me how to do this ?
Thank you,
Michal
[/quote]

There's two ways you can do this. Either do a VB script to rearrange the data, or create 3 substrings, then use truncation to only show the part of the string that you want for each part.
0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

Is this supposed to be a GS1-128 barcode by any chance for inter-company logistics labelling? If so then you should use the GS1 Application Idenetifier wizard that will help step you through the data sourcing process. Each data source could then be tweaked later if needed.

http://www.bartenderbarcodesoftware.com/label-software/whitepapers/BarTender%27s-Application-Identifier-Wizard.pdf

Please sign in to leave a comment.