2 Replies Latest reply: Mar 12, 2013 1:28 AM by 996218 RSS

    calculate a date from age(num),month(num),days(num)  subtruct by sysdate

    Selim_Rahman
      form 6i, database 10g xe

      i have 3 field age,month and days..they r all number format
      if any of this field entered age, month,date or any combination of these three field will return a date that subtruct from sysdate

      example:
      assuming sysdate= 12-03-13
      age   month    days  =  date
      2                           = 12-03-11
                 1                = 12-02-13
                            10   = 02-03-13
      it may be individual or any combination of age month and days, date will come by subtruct sysdate

      Edited by: Selim_Rahman on Mar 11, 2013 10:11 PM

      Edited by: Selim_Rahman on Mar 11, 2013 10:12 PM