EBIFour.com > Training > Clarify QRGs > Clarify 4.6+ Engine 2 :: Date Conversion Example 1

Clarify 4.6+ Engine 2 :: Date Conversion Example 1

21st March 2017

In Cleo Clarify 4.6+ we are trying to take the G6202 date (8 digits) and move it into an 8 digit field.

In the past it would have been a breeze.. With Clarify 4.6 (Version 2) we need to create multiple rules to make this occur.

In the example below we will make sure of 2 new actions/variables

  • Action: FormatDateTime
  • Variable: DateTime

Sample EDI

ST*940*0001^
W05*N*155098*^
G62*10*20170315^
LX*1^
W01*2*BX**VN*BNK-0481^
N9*L1*0001^
LX*2^
W01*1*BX**VN*BNK-0208^
N9*L1*0002^
SE*8*0001^

Moving Date: Overview

We need to move G6202 into E9ODTA

Cleo Clarify 4.6 Engine 2 x12 EDI 940 G62 segment, elements

Step 53: Move date into DateTime Variable:

Cleo Clarify 4.6 Engine 2 DateTime Variable

Step 54:Use Action FormatDateTime

With DateTime Variable move formatted date of yyyyMMdd into String Varible: g6202String

Cleo Clarify 4.6 Engine 2 FormatDateTime Action


Step: 55 Move String into Database 8 digit field

Cleo Clarify 4.6 Engine 2 Move Action

This is ALOT of work to move a simple value.

For more assistance or overview of Cleo Clarify 4.6, please feel free to CONTACT OUR GROUP.


By: on