DSXchange

Hi, I have a date formating issue. The below stage validation returns correctly (Else part) if the PeriodNum is in double digit i.e. say 10152004 In the 'Else' part if the LNK1.periodNum is 3 then it should return 03152004 instead of 3152004 IF(LNK1.TRANSACTIONTYPE = '100' ) Then '1215' : (LNK1.Year...

Hi, I have a requirement like in the below scenario I need to split source data in to multiples of 100 records and place a header record for them as given below H...A...B..C....D..............................................1 (sequence number) L1.........................E1.....F1.....G1......X.........

Thanks a lot ..

Hi,

Ereplace( Trim(Oconv(@DATE, "D YMD")), " ", "") returns 3152004 instead of 03152004 where 03 is the month and 15 is the date. Correct me if any format is missed out.

The data should be in the below format

mmddyyyy