Skip to Content
Former Member
Jul 16, 2013 at 05:14 AM

Restricting internal table data for date wise calculation


Dear Experts,
I have a data table with records of power readings stored Date wise. Now I have to create a report that does the calculations from the data as below.

1. Average of readings of last week's data.(last 1-7 days)

2. Average of readings of previous week's data.(last 8 - 14 days)

3. Average of reading of prev. month's data. (last 15 - 45 days).

Now my question is how to extract the data from table date wise as required.

Also if there is any way I can store only 45 data records starting from yesterday till last 45th day then pls help me how to achieve this ??