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

    date issue

    UPALI WIJERATNE

      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

       

      (C_DATE)-(I_DATE) AS NUMDAY

       

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