I am using following condition
if li_date ne 0 and ((logging_date - datejul(li_date)) <= 180) and (NEGAUTH_STAT_CD in ('LI') or NEGAUTH_REM1_STAT_CD in ('LI'))
I am getting error in datejul(li_date) function as few values of li_date = 0, i used li_date ne 0 to avoid this condition but error is keep comming.
when I changed NEGAUTH_STAT_CD in ('LI') to NEGAUTH_STAT_CD ='LI' , code works fine.
Could anyone explain, why in() operator shows error and = opertor doen't.