Date Field

Legacy Poster

• 17. November 2014 12:06

Hi im working on a label and id like to give it the following format

 

44M14

 

Work week (44)

Day (M)

Year (14)

 

(ddd) gives me Mon which is close but i cannot use it, any way around this?

I have tryed ti split the field into 3 different components and it just seems a bit messy

If there is a simpler way il like to hear for you

0

• 

  Fernando Ramos Miracle

  ★ BarTender Hero ★

  • 1. Dezember 2014 12:56

  Hello Anthony,

   

  Our custom date format will only allow you to use the abbreviated format (Mon) in your case. What you could do is "crop" the last two characters from the data string, for which you'll need to isolate the "day" value on a separate data source and apply a simple VB script to it.

   

  You can do the latter from the "Transforms" tab by activating the VB script option and adding the below code to the "OnProcessData" event:

   

  Value = Left(Value,1)
  

  This will basically take the first letter from the left of the date string and set it up as the data source's value.

   

  Regards.

  0

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