13 Replies Latest reply: Jun 4, 2014 3:30 PM by MyOAF RSS

    Months_Between in ODI 12c

    MyOAF

      I am trying to use the months_between in ODI 12c. The source table has a column called DOB and the target table has a column called "Age". I mapped the source.dob to target.age. In the expression MONTHS_BETWEEN(CURDATE(), INCR_TEST.DOB) and this always returns zero. When I tried to simulate , ODI converts this months_between as "months_between(INCR_TEST.DOB,INCR_TEST.DOB)" by taking out the curdate()..

       

      I tried using the SYSDATE instead of curdate() and the result is same. Any help?