Date format — from YYYYMMDDhhmm to YYYYMMDD

This topic has 1 reply, 2 voices, and was last updated 17 years, 8 months ago by Jim Kosloskey.

Creator

Topic
April 30, 2007 at 8:14 pm #49247
Ken Climer
Participant
I know there must be a simple way to do this, but I’m not discovering it.

I have an input file (HL7). The FT1 segments normally have the date format as the 12-digit YYYYMMDDhhmm, but I need to modify these to simply be the 8-digit YYYYMMDD.

I’ve searched through the forums, though I’m new to the forum… and Cloverleaf, in general.
Creator

Topic

Viewing 0 reply threads

Author

Replies
- April 30, 2007 at 8:38 pm #61252
  Jim Kosloskey
  Participant
  Ken,
  
  Here are a couple of things you can try.
  
  At the beginning of your Xlate add a DATECOPYOPT Action and turn off the ‘Add Presicision’ switch.
  
  If that does not do the trick, change the field length in your outbound variant to 8 bytes and Xlate will truncate for you. If you have more than one Date/Time field to be affected, change all that are necessary.
  
  Jim Kosloskey
  
  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
Author

Replies

Viewing 0 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.