Originally posted by: ICS_User_Shane

Hey guys, i have an issue trying to convert my GS05 time from HH:MM:SS to HH:MM.  I am using the standard Type Tree from ANSI for 4010.  The description says the Class Type and Format should allow for HH:MM.

I have tried the following:

=TODATETIME(CURRENTTIME(), "{HH:MM}")

=TEXTTOTIME(FROMDATETIME(CURRENTTIME(), "{HH:MM}"))

Each time my MTR file shows: 

The 0|LT|2200-126||| value actually comes from a different record format down at the Line level.  Not sure how WTX managed to do that.

Any help would be appreciated.

Shane 

Originally posted by: paul.brett

From what version of the WTX X12 Pack are you using this Typetree?  In the Typetree I have, 'Time Element V4010 ANSI EDI' is a category, and cannot be used as an output object.

When I use 'Short Other Time Element V4010 ANSI EDI', and the rule:

=CURRENTTIME()

....I get the correct output : '0831'

Thanks

Paul

Follow me on Twitter

Originally posted by: paul.brett

I have found a newer version of the Typetree (from IBM WebSphere Transformation Extender Pack for X12 v2.8.1.2) and it shows 'Time Element V4010 ANSI EDI' as an object.

The output of this object is determined by a combination of the object properties, and the rule.  The properties are defined thus:

<ITEM SimpleTypeName="Time" CategoryOrItemParent="Element V4010 ANSI EDI" Description="Time as HHMM or HHMMSS or HHMMSSDD(337 V4010)" partition="NO" OrderSubtypes="ASCENDING"><CharDatetime><CharDateTimeFormatString>{HH24MM[SS[1-2]]}</CharDateTimeFormatString>
<PadText Justify="LEFT" ApplyPad="ANYCONTEXT"><PadValue>&lt;SP&gt;</PadValue>
<PaddedToMinContent CountsTowardsMinContent="YES" PadUsing="BYTES"/>
</PadText>
<Western CharSet="NATIVE"/>
<ValueRestrictions IgnoreCase="NO" Rule="INCLUDE"></ValueRestrictions>
</CharDatetime>
</ITEM>

...and a rule of:

=TEXTTOTIME(LEFT(TEXT(CURRENTTIME()),2)+MID(TEXT(CURRENTTIME()),4,2))

...should get you the result you desire.

Let us know how that goes.

Thanks

Paul

Follow me on Twitter

Originally posted by: paul.brett

Files....

Thanks

Paul

Follow me on Twitter

Attachment(s)

4010.zip   1 KB 1 version

Originally posted by: paul.brett

Rule :

=TEXTTOTIME(FROMDATETIME(CURRENTTIME(), "{HH24MM}"))

...would also work.

Note that HH is NOT a valid format.  HH12 or HH24 is.  The colon also needs to be removed).

Thanks

Paul

Follow me on Twitter

Originally posted by: ICS_User_Shane

Hey Guys,

Thanks so much for the input.  After all this, i shut down the 8.1 mapper tool and restarted the dev server.  I tried my =TEXTTOTIME(FROMDATETIME(CURRENTTIME(), "{HH24MM}")) command and low and behold it worked.

Our enterprise WTX folks have plans on upgrading our division to 8.4 this summer.

Sometimes this thing just gets so buggy.