Hi all, m trying to write a function which simply returns (Report_date - payment_date) n gives total "NO OF DAYS" but there is one condition that for each month i have to consider 30 days only.
Eg. if the Report_date is "31-dec-2009" and payment_date is "30- oct-2009" , then ideally the answer is 62 days,but as per my requirment each month have 30 days only so i have to ignore 31st Oct as well as 31st Dec.so it'll return 60 days only. In other case if the calculation includes month "Feb" then it'll also treated as 30 days month. Can any body help me... Regards: KD -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
