Best before date Follow

0
Avatar
Chris Dinham

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 

1 comments

0
Avatar
Shotaro Ito
Comment actions Permalink

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)

 

Please sign in to leave a comment.