Skip to main content

Search

Search

Current Date Plus Experation Date Via Database

Comments

6 comments

  • Avatar
    Ian Cummings
    Moderator
    What edition and version of BarTender are you using, or are you running with the Trial?
    0
  • Avatar
    Legacy Poster
    9.4 Professional not a trial
    0
  • Avatar
    Legacy Poster
    The below works for me I think. Multi-Line VB script in the field you need:

    datestart = FormatDateTime(<DATABASE FIELD>,2)
    Value = DateAdd("d",180,datestart)
    0
  • Avatar
    Shotaro Ito
    Consider you have number (180 or 35 etc) in a text datasource.
    Text properties > More options > VB Script > OnProcessData
    [code]If IsNumeric(Value) Then
    Value = DateAdd("d",Value,Date)
    End If[/code]
    0
  • Avatar
    Ian Cummings
    Moderator
    You might like to know that we have just released v10 of the BarTender Suite on Thursday afternoon, which among many new features supports date offsets from a database field directly without the need to use VB script.

    If you are interested in upgrading or just testing the latest version, then feel free to download the Trial at the below link:

    http://www.seagullscientific.com/aspx/free-bar-code-label-printing-software-download.aspx

    For full details on the new features in BarTender Suite v10 please take a look at the What's New in BarTender v10 white paper:

    http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_WhatsNewInBT10.pdf
    0
  • Avatar
    Legacy Poster
    I have found a bug with this.

    I link in from an excel spreadsheet. The offset figure is a field in the spreadsheet.

    If we select the labels to print at printing time and we choose different product from our "database" it picks up on the first offset number in the database and that gets used for all the products.

    eg. Say I have threee product

    Product1 with offset of 3 months
    Product2 with offset of 10 months
    Product3 with offset of 8 months

    If I select each product individually at printing time it works as expected. The date is offset by the offset ammount set in the excel sheet. However if I want to select and print all three (and they are listed in order as above) it takes only the offset from the first list, in example above 3 months and uses that for all three labels.

    [quote name='Ian C - Seagull Support' timestamp='1330674528' post='1881']
    You might like to know that we have just released v10 of the BarTender Suite on Thursday afternoon, which among many new features supports date offsets from a database field directly without the need to use VB script.

    If you are interested in upgrading or just testing the latest version, then feel free to download the Trial at the below link:

    http://www.seagullscientific.com/aspx/free-bar-code-label-printing-software-download.aspx

    For full details on the new features in BarTender Suite v10 please take a look at the What's New in BarTender v10 white paper:

    http://s3.amazonaws.com/SeagullBarTender/ftp/WhitePapers/WhitePaper_WhatsNewInBT10.pdf
    [/quote]
    0

Please sign in to leave a comment.