code issue... need help
Posted: Tue Jul 14, 2009 11:45 am
hi guys
im working on a program here and here is the rule
=EITHER(
IF(SIZE(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:In1,Ref#Qual'r Element:REF Segment:LoopCLM2300:In1="D9"))>19,TEXTTODATE(RIGHT(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:In1,Ref#Qual'r Element:REF Segment:LoopCLM2300:In1="D9"),6))),
IF(SIZE(LOOKUP(Ref# Element:REF Segment:IN3,Ref#Qual'r Element:REF Segment:IN3="D9"))>19,TEXTTODATE(RIGHT(LOOKUP(Ref# Element:REF Segment:IN3,Ref#Qual'r Element:REF Segment:IN3="D9"),6 ))),
IF(SIZE(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:LoopHL2000C:In1,Ref#Qual'r Element:REF Segment:LoopCLM2300:LoopHL2000C:In1="D9"))>19,TEXTTODATE(RIGHT(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:LoopHL2000C:In1, Ref#Qual'r Element:REF Segment:LoopCLM2300:LoopHL2000C:In1="D9" ),6)), TEXTTODATE(FROMDATETIME(FileDate, "CCYYMMDD")))
)
the thing about this code is that regards if the data satisfies the older rule, this is ignored and the data that satisfies the last condition TEXTTODATE(FROMDATETIME(FileDate, "CCYYMMDD"))) is the one getting mapped. When I removed that code segment, the correct data is not being mapped. Unfortunately, i can not ermoved that code segment since the old rule is a backup in the event that eh new data is not available then the field will have the old data. problem is the old data keeps on getting mapped even if the new one comes along. any thoughts about this issue is greatly appreciated.
thanks
im working on a program here and here is the rule
=EITHER(
IF(SIZE(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:In1,Ref#Qual'r Element:REF Segment:LoopCLM2300:In1="D9"))>19,TEXTTODATE(RIGHT(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:In1,Ref#Qual'r Element:REF Segment:LoopCLM2300:In1="D9"),6))),
IF(SIZE(LOOKUP(Ref# Element:REF Segment:IN3,Ref#Qual'r Element:REF Segment:IN3="D9"))>19,TEXTTODATE(RIGHT(LOOKUP(Ref# Element:REF Segment:IN3,Ref#Qual'r Element:REF Segment:IN3="D9"),6 ))),
IF(SIZE(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:LoopHL2000C:In1,Ref#Qual'r Element:REF Segment:LoopCLM2300:LoopHL2000C:In1="D9"))>19,TEXTTODATE(RIGHT(LOOKUP(Ref# Element:REF Segment:LoopCLM2300:LoopHL2000C:In1, Ref#Qual'r Element:REF Segment:LoopCLM2300:LoopHL2000C:In1="D9" ),6)), TEXTTODATE(FROMDATETIME(FileDate, "CCYYMMDD")))
)
the thing about this code is that regards if the data satisfies the older rule, this is ignored and the data that satisfies the last condition TEXTTODATE(FROMDATETIME(FileDate, "CCYYMMDD"))) is the one getting mapped. When I removed that code segment, the correct data is not being mapped. Unfortunately, i can not ermoved that code segment since the old rule is a backup in the event that eh new data is not available then the field will have the old data. problem is the old data keeps on getting mapped even if the new one comes along. any thoughts about this issue is greatly appreciated.
thanks