Need help: VBScript date output ignoring Data Type Pattern (MM/yyyy)

Francisco Amaya

• 10. Oktober 2025 19:02

Hi everyone,

I’m working on a BarTender label where I’m using a VBScript to evaluate a field called MfgDate from a TXT data file. The goal is to display the field’s date if it exists, or today’s date if the field is empty. 

I'm using a basic script as follows:

If Field("MfgDate") = "" then
  value = Date() 
Else 
  Value = Field("MfgDate")
End if

I'm ignoring the following warning:

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 13. Oktober 2025 09:54

  I believe you need to make the field an Event Controlled VB Script field itself, using the OnNewRecord option to make sure the VB is processed at the correct time. 

  0
• 

  Francisco Amaya

  ★ BarTender Hero ★

  • 14. Oktober 2025 12:22

  Thank you Peter. I have never tried that, but I will try it today and update this case for further reference  

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.