4 Replies Latest reply: Jan 4, 2015 6:23 AM by Dhanushka siriwansha RSS

    No of dates calculation

    Dhanushka siriwansha

      Hi,

      I need to calculate no of dates in new field. I made it as follows in script. But its not working. need your help......

       

      LOAD *, Interval([LOSS_DATE]-12/31/2014) as 'DURATION';

      Load * Inline 

      LOSS_DATE

      18-Jun-14

      18-Jun-14

      21-Jun-14

      9-Jul-14

      18-Jul-14

      5-Jul-14

      ]; 

       

      Thankz,

      Dhanushka.