Best before Date on label based on Database field
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?
-
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 -
The offset seems to work perfectly and solve our problem. Thank you so much!
0 -
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.
0
Please sign in to leave a comment.
Comments
3 comments