That is not my issue. I can get the HI_DATE and LO_DATE to be inserted. What I cannot do is have the LO_DATE inserted in the Begin_Date when it is a new record and &YYMD inserterd in the Begin_Date when it is a changed record.
Here is how I have the variable set in the data flow.
-
![Big Grin](https://forums.informationbuilders.com/groupee_common/emoticons/icon_biggrin.gif)
EP_2
-TYPE (ICM18097) DEP_2: Set variables
-DEFAULT &&PROCESS_DATE = &YYMD
-SET &LO_DATE = 19000101;
-SET &HI_DATE = 99991231;
-SET &&TYPE_II_DT_NAME = 'EFF_DATE';
-SET &&CM__SCDEIDT = DATE_B4_UPDATE;
-SET &&CM__SCDEADT = &HI_DATE;
-SET &&CM__SCDATE = '(IF D.END_DATE EQ &HI_DATE.EVAL THEN &&TYPE_II_DT_NAME.EVAL ELSE &LO_DATE.EVAL)';
-GOTO
![Big Grin](https://forums.informationbuilders.com/groupee_common/emoticons/icon_biggrin.gif)
EP_MAIN;
EFF_DATE is defined in the flow as &&PROCESS_DATE and DATE_B4_UPDATE is defined as EFF_DATE - 1
My end dates for the Type II work fine. It is the Begin_Date I am struggling with
WebFOCUS 7.6
Windows, All Outputs