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

Francisco Amaya

• October 10, 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 ★

  • October 13, 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 ★

  • October 14, 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

Please sign in to leave a comment.