This discussion is archived
7 Replies Latest reply: Dec 9, 2012 9:37 PM by O.Developer RSS

Months Between format

Moazam Shareef Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points