Datecode Folgen

0
Avatar
Legacy Poster

Hi

I am hoping someone can help with this one. I have a Customer that is asking for a different date code than the standard it is as follows.

First Problem

MDD

(M = Month of the Year in letter)
(D = Day of the month in number format)

without any separation.

Second Problem they want the Month as follows.

January = A
February = B
March = C
etc.


Example: J03 = 3rd of October

Apart from doing this letter manually is there anyway of setting this up to change automatically.

Thanks

Darren Prior

2 Kommentare

0
Avatar
Legacy Poster
Aktionen für Kommentare Permalink

You could use VB script

0
Avatar
Shotaro Ito
Aktionen für Kommentare Permalink

Alternatively - 

In BarTender 10.0 or later you have "Search and Replace" transform. In there you can have several actions such as 10 to J.

Unfortunately that only apply to Text data type, so you need to change Clock data type to text data type.

 

so create a date text (you can place off-label or set to not print) and another text (for Mdd).

on the Mdd text, create 2 data sources - for month and date. both data source are object value of the date text.

for date, you can simply derived from truncation transform.

for month, first you get "MM" part from truncation, then in Search and replace transform, apply actions.

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