I have a requirement where in i have to prorate a real value based on the no of the days of usage per bill cycle. I am getting below values as input.
1) Volume (integer /real value) - for example : 5000
2) No of Days of Usage (integer /real value) : for example : 20
3) No of Billing Days in Bill Cycle : For this i am not getting a straight value, instead bill cycle start date (date / timestamp) and bill cycle end date ((date / timestamp) is being passed using which i need to find the difference between them and convert it in to real/integer value to use it in the below given calculation
Prorated Volume = ( No of Days of Usage / No of Billing Days ) * Volume
Ex: Prorated Volume = (20/30) * 5000 = 3333.33
The difference ( i.e. No of Billing Days) between two timestamps results in a duration which cannot be type caste to integer or real directly to use it further for calculation.Please let me know if there is a possibility to achieve the above problem as soon as possible.