Best before date

Chris Dinham

• 2017年10月25日 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 ★

  • 2017年11月07日 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

请先登录再写评论。