Bifurcation

[varunjain]

Hi,

There is this scenario wherein user wants to bifurcate data on the monthly basis.

We have a table with Start_date, End_Date and Amount.Suppose one record is like

03-10-2012,30-06-2013,16000 respectively.

Now the requirement is that instead of this one record, the data should be bifurcated month-wise, like:

03-10-2012,31-10-2012,2000

01-11-2012,30-11-2012,2000

01-12-2012,31-12-2012,2000

.

.

.

.

01-06-2013,30,06,2013,2000

How can this be attained? Please help

[#2]

Hi Varun

Please see the attached file.

Please note, your example covers 9months (not 8months) so the value per month is 1777.78 (16000/9).

Let me know if this is the correct and/or helpful answer.

Regards

Steve

[#3]

Hi

Did the code solve your issue?

Thanks

Steve