Change Date Format Based On Database Value 关注

0
Avatar
Legacy Poster

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.

1 评论

0
Avatar
Domingo Rodriguez
版主
评论操作 固定链接

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

请先登录再写评论。