Best before Date on label based on Database field Follow

0

Hi,

can anyone give me a hint how to set a best before date on our labels?
Our labels are connected to a database which has a field for its shelflife in months.

We have the field on the label set as a clock field which is altered by VB Script:

 

Value = DateAdd("M",Field("Bartender-DB.Lagerwareberechnung.MHD in Monaten"),Value)

 

The Italic Text is our [Excel Database].[sheet].[field]

 

However this Date field appears to cause some errors when printing multiple print jobs from the same file.

 

Is there different way to create the best before in combination with the database?

3 comments

0
Avatar
Peter Thane
Comment actions Permalink

Depending on how new a version of BarTender you are running, then this option may work for you. 

If you are using the VBScript method with a database link then you would probably need to run the DateAdd command as an Event Controlled Script, OnNewRecord and so that the data calculation is carried out every time a new databse record is selected/printed

0
Avatar
Tobias Gessner
Comment actions Permalink

The offset seems to work perfectly and solve our problem. Thank you so much!

0
Avatar
Peter Thane
Comment actions Permalink

No worries. 

The Apply offset after data entry is a great little feature too, saved me loads of VB script working, where the production day is not the same as the date the labels are printed and then a database offset was needed to for example.

Please sign in to leave a comment.