Originally posted by: Shane.kelly55

Hey Guys,

I got an easy one for you.  I have an X12 output card with an item with a subclass of Date & Time with a format of {HH24MM[SS[1-2]}.  My Trade Partner only wants HH:MM:SS but not matter what function/rule i apply i always get the extra 2 characters in HH:MM:SS:SS.  I assume that last 2 is mili seconds or fractions of a second.

I have used every combo of FROMDATETIME, TIMETOTEXT etc trying to find ways of only writing the 6 characters i need rather than the 8.

What am i doing wrong here?  I feel dumb!!

Thanks,

Shane

Originally posted by: pcp

Hi Shane,

I have faced this issue many times as well.

There are a couple of solutions:

1) Update the type tree to {HH24MM[SS]}, this way you will definitely get the 6 characters as supposed to the 8. (But make sure this "time" field is not used in other parts of the type tree)

2) Change the field to a text field and use the FROMDATETIME function to convert the time to the desired format.

Thanks,

Phil

Originally posted by: Shane.kelly55

Hey Phil,

THanks for responding.  I cant change the Type Tree so am i correct in assuming even if i instruct WTX to put HHMMSS in that field, WTX will assign the last two characters?

EDIT: I got it working with =TEXTTOTIME(LEFT(TIMETOTEXT(Time), 6))

Originally posted by: pcp

Hi Shane,

That's great you were able to come up with a solution using mapping functions.

Yes that is correct, for some reason that was what happened. I was stumped as well.

Since we had the option of updating the type tree, I used the first option I had provided.

Phil