CASE WHEN TO_DATE({custbody5},'dd/mm/yyyy') > TO_DATE({trandate},'dd/mm/yyyy') 1 ELSE 0 END didn;t work