Change Date Format Based On Database Value

Legacy Poster

• September 27, 2013 12:56

Is the any way to change the format of a date based on a database field.

 

For example:

 - Database is queried for the product number.

 - The operator picks a manufacturing date with a date picker control.

 - The picked date is offset by number of months specified in the database.

 - I need the date after the offset to display as "MM/yy" for USA destination and "yy/MM" for Korea destination.

 

I'm using version 10.1 sp1 professional edition.

 

Current solutions is to use multiple data sources for the same data one for each different format.  The using scripts data is only populated into 1 field.  I feel like there should be a simpler way.

0

• 

  Domingo Rodriguez

  Moderator

  ★ BarTender Hero ★

  • September 30, 2013 08:34

  There is indeed a better way, but it would require you to purchase the Automation Edition of BarTender. In v10.1 we now support both Template and Layer conditional printing. With layers, you can create two different layers (each layer will show the date object in a different format), and at print time, thanks to the conditional layer printing, only one

  of the layers will be printed: http://www.bartenderbarcodesoftware.com/label-software/whitepapers/WhitePaper_WhatsNewInBT101.pdf

  0

Please sign in to leave a comment.