Code: Select all
If PROGRM = 999 AND
Not (CODE[1,3] >= 551 and CODE[1,3] <= 562) AND
Not (CODE[1,3] >= 890 and CODE[1,3] <= 889 AND
((CODE2[1,3] >= 581 AND CODE2[1,3] <= 591 ) OR
( CODE2[1,3] >= 641 AND CODE2[1,3] <= 645 ) OR
( CODE3[1,3] >= 581 AND CODE3[1,3] <= 591 ) OR
( CODE3[1,3] >= 641 AND CODE3[1,3] <= 645 ))
AND REC_CD IN ( '925', '926', '928','929','930')
THEN
DAY = '210'
ELSE
DAY = '221'
I mean like
Code: Select all
If PROGRM = 999 THEN
IF Not ((CODE[1,3] >= 551 and CODE[1,3] <= 562)) THEN
IF Not ((CODE[1,3] >= 960 and CODE[1,3] <= 979) THEN
IF (CODE2[1,3] >= 581 AND CODE2[1,3] <= 591 ) THEN
DAY = '210'
END END END END
ELSE '221'
I hope I will get helped to figure out the best way.
thanks