13 Replies Latest reply on Jun 4, 2014 8:30 PM by MyOAF

    Months_Between in ODI 12c


      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?