7 Replies Latest reply: Dec 9, 2012 11:37 PM by O.Developer RSS

    Months Between format

    Moazam Shareef
      Guyz,

      im doing some calculation in my form below are the formula.
      MONTHS_BETWEEN(SYSDATE,:CTRL.JOIN_DATE)/12 + 
      MONTHS_BETWEEN(SYSDATE,:CTRL.EFF_DATE,/12+
      NVL(:CTRL.TOT_TK,0)/12*12
      the above calculation is working fine but when CTRL.EFF_DATE is null then formula is not working, how can i by pass if EFF_DATE IS NULL then calculate only JOIN_DATE + TOT_TK or else calculate all. JOIN_DATE+EFF_DATE+TOT_TK

      Im using forms 6i. oracle 9i.


      Regards

      Edited by: Moazam Shareef on Dec 9, 2012 12:57 AM