Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My scenario is
In my table I have two fields Date and Amount.
I need to split the set of dates based on the given input.
Like,
If I gave input as 10, then it should split dates in 10. From 01-09-2012 to 10-09-2012, 11 to 20 and so on and the sum of amount to be calculated for the date frame.
For Example,
Date Amount
01-09-2012 10
02-09-2012 10
03-09-2012 10
04-09-2012 20
05-09-2012 20
06-09-2012 20
Input value = 3
output:
DateFrame Amount
01-09-2012 - 03-09-2012 30
04-09-2012 - 06-09-2012 60
Thanks in Advance.
Regards,
Leni
Any help??
Using Class function we can achieve this.
Sample is attached