Best before date

Chris Dinham

• October 25, 2017 09:15

Hey guys.

Im wondering if there is a way of calculating a best before date from a made by date that comes from a manually added text field. 

I have text box with a date input mask that points to a text string on the label. 

Id like that date to be used to calculate 14 months forward from the date added. 

iv been trying to adapt this somehow but with no luck
FormatDateTime(dateadd("m",14,now),2)

thanks for any help 

Chris 

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • November 07, 2017 05:04

  For BarTender 10.0 or later includes Ver 2016, You can refer other text's value by Object value data source.
  Then specify data type as Date, then apply Offset transform with 14 months.

  Text 1: Data source: Clock, Data Type: Date, Linked to form's Date Picker

  Text 2: Data source: Object Value (of Text 1), Data Type: Date, Transform: Offset 14 months 

   

  For versions before, you can apply OnProcessData VB Script.
  Text 2 created as the same (object value). More options > VB Script,

  OnProcessData:

  Value = DateAdd("m",14,Value)

   

  0

Please sign in to leave a comment.