Data extract at day level.

I have model calendar as week 4-4-5,4-5-4,5-4-4 and has day list with list items as Monday, Tuesday.... to sunday. So some days of last week in January are falling into February and so on. So I have to extract the data of extra days falling into february from February data. For example, last 6 days of January are falling into February. So how can I fetch data of those 6 days at day level i.e., either from Monday to saturday or tuesday to Sunday to subtract from February data and add to January data. How can I found what those days(Monday, Tuesday etc) are and how can I extract sum of data of those 6 days. I have to repeat this for every month.

 

I hope I will get solution soon.

Thanks

Shirisha.

Tagged:

Answers