15 Replies Latest reply: Nov 10, 2016 4:28 AM by Payal Shah RSS

    date issue


      I have in my data load script has a date field (T_DATE) . I have modified this in the follwing way


            IF(POL_TYPE='F',T_DATE) AS C_DATE,

            IF(POL_TYPE<>'F',T_DATE) AS I_DATE

      I also added following line to the script in order to calculate the no of days between  I_DATE and C_DATE




      But NUMDAY is blank in the output table. Have i done any error? How can I do the calculation correctly. Pls help