This discussion is archived
2 Replies Latest reply: Mar 11, 2013 11:28 PM by 996218 RSS

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

Selim_Rahman Newbie
Currently Being Moderated
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

Legend

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