Formating issue
Posted: Thu Jul 22, 2004 12:58 am
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 - 1)
Else
LNK1.PeriodNum : '15' : LNK2.Year
Without going for OConv is there any other logic.
Thanks in Advance
Badri
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 - 1)
Else
LNK1.PeriodNum : '15' : LNK2.Year
Without going for OConv is there any other logic.
Thanks in Advance
Badri