Dear All,
i want a formula is using following scrip
LOAD BCOD,
CLA_CODE,
PRD_CODE,
POLICY_NO,
REF_NO,
DATE(floor(MARKETING_DATE)) as MARKETING_DATE,
HISTORY,
//MARKETING_DATE,
MDATE,
YEAR,
MONTH,
NAME,
ME_CODE,
//TRN_DATE,
DATE(floor(TRN_DATE)) as TRN_DATE,
TRAN_YEAR,
TRAN_MONTH,
//POL_PERIOD_FROM,
SCCOD,
CP,
RS,
TC,
PF,
LIFE,
VAT,
CESS,
NBL,
GROSSTOT,
TYPE,
N_R_NOS1,
F_NOS2,
REFUND_TYP
and i want
MARKETING_DATE(REFUND_TYP='R',POLICY_NO)<MARKETING_DATE(REFUND_TYP='A',POLICY_NO) AS RE_ACTIVE
THANKING YOU
SAGARA
