DateAdd - OnProcessData [...] 'DateAdd'

Pascal Laframboise

• July 16, 2018 17:26
• Edited

Hello fellow VBscripter, 

 

I'm currently trying to make a label with today date and expiration date using a DB day field.

 

Here's the script : 

expdate = DateAdd("d", Field("BD_bartender.Boulangerie_us.Durée de vie"), Format.NamedSubStrings("date").Value)

Select Case Month(expdate)

Case 1 value = "JAN"
Case 2 value = "FEB"
Case 3 value = "MAR"
Case 4 value = "APR"
Case 5 value = "MAY"
Case 6 value = "JUN"
Case 7 value = "JUL"
Case 8 value = "AUG"
Case 9 value = "SEP"
Case 10 value = "OCT"
Case 11 value = "NOV"
Case 12 value = "DEC"

End select

value = value & "-" & Day(expdate) & "-" & Right(Year(expdate), 2)

 

When I click Test Script. It give me JUL-07-19.

But when I print the label, I got this error : 

OnProcessData(Line 3): : Argument .... incorrect: 'DateAdd'.

 

I can't figure out what's wrong. 

 

Many thanks,

 

 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • July 17, 2018 08:21

  Hi Pascal,

  I guess you noticed the expdate and dateexp mix up and have fixed that already.

  I believe the issue could be when the VB is trying to perform it's action. As you are using information taken from a database then the VB script needs to run after the information has been read into the file. To do this you will need to change the VB type to an Event Controlled Script and (from the look of the above) the OnNewRecord instance option.

  Pete 

   

  0

Please sign in to leave a comment.